I tried importing my production data to development, every time i do this i get error for many tables and some tables get imported. what I assume for the cause of error is if there are any tables with relationships,FK's there should be an order of tables to import. Like a parent table has to be imported first before the child table(correct me if am worng) What is the best way to get production data into developemt by deleting existing data in devlopment. I dont want to do a restore, just need to do it from DTS which i can use for future.
What is the error? By default DTS is best in this csae and you can choose stating overwrite existing data or you can write TSQL to take only newer rows. =
I know you're asking for an alternative, but a restore is really the easiest option. It also is the best way to work out how to implement your proposed changes in the production database ...
I would second Adrian's opinion in this case to handle such data migration and also best to tackle the changes you need to perform as per the live environment.
