Compares and synchronizes SQL Server databases, backups and scripts.
Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong
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 6:08 pm
I have logged a support ticket for you and will email you shortly!
- Posts: 692
- Joined: Mon Apr 20, 2009 3:53 pm
- Location: Cambridge
Was there ever a solution for this issue?
- 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 1 guest