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
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.

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