How to refresh database data only in SQL Server

Posted by MaxGeek on Stack Overflow See other posts from Stack Overflow or by MaxGeek
Published on 2010-06-08T21:13:18Z Indexed on 2010/06/08 21:22 UTC
Read the original article Hit count: 199

Filed under:

So I want to copy just the data from a Prod database (SQL 2005) down to my local machine (SQL 2005 & SQL 2008 Management Studio installed).

The problem is I'm running into foreign key constraints that are causing the task/scripts to fail. I can get by these errors if I import certain tables first, but is there an easier way to do this all at once? I'm not a DBA so I don't have access to the database back up.

I've tried the SQL Import/Export data Wizard and Publishing Wizard, but it also gets the PK error.

© Stack Overflow or respective owner

Related posts about sql-server