SQL Server Performance Forum – Threads Archive
Copy a Database
I’m trying to use DTS to copy all data/objects/SPs/views to a different server, basically copying the production data to my development box to update it.I keep getting a failure on some tables regarding Foreign Key constraints.
How do I do this? Is there a certain order I need to follow?
I’m currently using the Copy Data and Ojects option. Any tips? Thanks!
See, if this helps:<br /<a target="_blank" href=http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546>http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546</a><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br /><br />———————–<br />–Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />———————–<br />
Similar threadhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=5972 for reference. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>