Friday, February 17, 2012

copy struture of tables without loosing data

HI
I need to copy the table structures from my production database to development database but not loose the data in developement. Is there a way to achive this by creating some scripts.
thanksYou want to copy some tables from your production environment to devleopment? If so have you tried DTS?|||In your approach, you need to prevent to re-create your tables, and you simply have to append the data. DTS is the most suitable tool, there are other ETL tools as well, and, not recommended, you can write your transformation process in a varity of languages.

I'd be glad to hear your approach.

No comments:

Post a Comment