Red Gate forums :: View topic - Copy from one database to another and change schema
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Copy from one database to another and change schema

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
DarrenGuy



Joined: 09 Sep 2011
Posts: 5

PostPosted: Wed Mar 12, 2014 5:16 pm    Post subject: Copy from one database to another and change schema Reply with quote

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.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 684
Location: Cambridge

PostPosted: Mon Mar 17, 2014 12:11 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
firley



Joined: 22 May 2014
Posts: 1

PostPosted: Thu May 22, 2014 6:11 am    Post subject: Reply with quote

Was there ever a solution for this issue?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group