Copy from one database to another and change schema

Forum for users of SQL Compare schema synchronization utility

Copy from one database to another and change schema

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

I have two databases


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.
Posts: 5
Joined: Fri Sep 09, 2011 5:08 pm

Postby Anu Deshpande » Mon Mar 17, 2014 11:11 am

I have logged a support ticket for you and will email you shortly!
Anuradha Deshpande
Product Support
Redgate Software Ltd.
Anu Deshpande
Posts: 758
Joined: Mon Apr 20, 2009 2:53 pm
Location: Cambridge

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

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

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: Google [Bot] and 0 guests