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
sql-server
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