Moving subsets of data between servers

Last Post 28 Dec 2009 07:37 PM by gtylar. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
JustinBailey
New Member
New Member

--
26 Dec 2009 08:12 AM
I have a fairly complicated SQL Server database (around 300+) tables and I need to move portions of those tables to another SQL Server database instance.

My client has all his customer's data in one big database. One of those customers decided that for security reasons, they wanted their database onsite. Now I have to move all the data, for just that customer, to another database. This customer's data is spread all over the 300+ tables and it's fairly normalized so lots of parent-child relationships, etc...

Has anyone ever tried to do something like this? Do I just have to write scripts/sql to do it manually? I was hoping for something easier than just writing all the sql.

Cheers,
Justin
gtylar
New Member
New Member

--
28 Dec 2009 07:37 PM
Check out Relational Migration
I don't know how well it performs with HUGE data sets, but it works well for us. We use it to move configuration data from a development environment to production.


Acceptable Use Policy
---