Copy from one database to another and change schema

Compares and synchronizes SQL Server databases, backups and scripts.

Copy from one database to another and change schema

Postby DarrenGuy » Wed Mar 12, 2014 5:16 pm

I have two databases

db1
db2

I am looking to merge the contents of the two databases. In both both databases, all objects belong to the dbo schema.

What I am looking to do it to move all objects and data from my db1 database into my db2 database, but instead of the objects being part of the dbo schema, I want all the objects to belong to a new schema. e.g cms

Looking at sql compare project options, as the objects don't already exist I cannot do any mapping.

Is there an easy way using SQL Compare and SQL Data Compare to do what I wish to do, or is my best bet to just use a tool to generate the create object script and then do a search and replace on the text replacing all instanced of [dbo] with [cms]?

And then once these objects have been created do a mapping exercise.
DarrenGuy
 
Posts: 5
Joined: Fri Sep 09, 2011 6:08 pm

Postby Anu Deshpande » Mon Mar 17, 2014 12:11 pm

I have logged a support ticket for you and will email you shortly!
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby firley » Thu May 22, 2014 6:11 am

Was there ever a solution for this issue?
firley
 
Posts: 1
Joined: Thu May 22, 2014 6:09 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests