May 10, 2002 at 5:12 am
i have a db on sql 2000. i need to make a copy of that db on the same sql2k server. If I create a new db and use dts to extract all the data from 1 db into the other will these 2 db's be identical in both content and fuctionality. I did this on a test server and it seems to have extracted everything and they look identical.
May 10, 2002 at 6:05 am
It should be but may miss items like references. To really get an exact duplicate you can perform a backup of the first DB and force restore over the new one, this will guarantee exactness.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 10, 2002 at 6:01 pm
thank you i will do just that
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply