UI - Refresh to another catalog

Posts   
 
    
Fabrice
User
Posts: 180
Joined: 25-May-2004
# Posted on: 26-Jun-2006 18:35:04   

Hi,

I've a small question I want to refresh my project but on another database than the normal database used for schema refresh. But in the catalog name list, the current catalog is checked and disabled so I can't uncheck it. Can someone tell me how to do that ? What will be the behaviour if there are 2 database selected ? (with small differences in the schema)

Thank you

bclubb
User
Posts: 934
Joined: 12-Feb-2004
# Posted on: 27-Jun-2006 02:25:47   

To change the database navigate to the Catalog Explorer. This is usually on the right side of designer. Now expand Catalogs. You should see your old database name; right-click it and choose Rename. Now you can change the name of the database.

Now when you do a refresh any changes between the two databases will just look like an update to your old database.

Fabrice
User
Posts: 180
Joined: 25-May-2004
# Posted on: 27-Jun-2006 10:45:25   

Perfect! Thank you