Database Software

Here is my situation.

Source server
================
Project name : SOURCEOWB
Under this project, we have two module(MBTSOURCE, MBTTARGET).

In connection explorer, the locations are DW_MBT_SR, DW_MBT_TR.

We have 15 mappings on this project.

Source schema name is TXMBT_DW.
Target schema name is MBTTX_DW.

I want to migrate the whole thing to new server.

Here are the info about target location. After migrating to new server, i need to rename
as below.

Project name : CA_SOURCEOWB
Under this project, we have two module(CA_MBTSOURCE, CA_MBTTARGET).

In connection explorer, the locations are CA_DW_MBT_SR, CA_DW_MBT_TR.


Source schema name is CA_TXMBT_DW
Target schema name is CA_MBTTX_DW

Here are my steps i followed.
===============================

1. Created the source and target schemas in new machine.
2. Create a new workspace
3. Export the mapping with dependent objects from source server and imported in new server.
4. changed the source and target location successfully.
5. Renamed the project namd, module names as i needed successfully.

But only issue is, i am not table to change the location name.

Again, i tried the below steps.

1. uninstall the workspace and create the workspace
2. create source and target locations as i needed(CA_DW_MBT_SR,CA_DW_MBT_TR).
3. import only mapping
4. Able to register the mapping

Here i am not able to configure the module for newly created locations.

I right clicked on module and click Configure, go to Stream Administrator and not able to find
the source and target locations over there.....

How do we resolve this?


My data warehouse is runing for each state. I want to copy one state mapping and import into
another state and customize the mapping. I have hard time to change the location name. Because,
location name has state code. I can not use the same location name for all other state.

Any help is highly appreciated.