View Single Post
  #4 (permalink)  
Old 02-25-06, 11:35
Thrasymachus Thrasymachus is offline
SQL Server Street Fighter
 
Join Date: Nov 2004
Location: Down The Rabbit Hole
Posts: 7,766
are you completely refreshing the data or just adding to it?

if you are completely refreshing the development environment disable the constraints in a sql task, truncate the development tables import your data and re enable the constraints

or just DTS your data in the right order. Child tables first, and then the parents. For this you can use the DTS wizard because it choose the order. You are going to have to build a custom package with precedence constraints on your tasks. Personally I would use BCP or BULK INSERT. By default constraints are not checked using these methods but you are going to have to build staging tables for your exports (for which you need bcp) because you are basing the said export on a query.
__________________
software development is where smart people go to waste their lives
Reply With Quote