Copy a Database | SQL Server Performance Forums

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=;EN-US;314546>;EN-US;314546</a><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />———————–<br />–Frank<br /<a target="_blank" href=></a><br />———————–<br />
Similar thread for reference. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.