I have a huge project ahead of me and I am hoping that there is some magical SQL wizard or some statement that will do a bulk copy. I did some research on this and the wizard and the bulk copy SQL will not work so, I need your help. Here is my situation. I have this elaborate database (2001-current) it contains stored procedures, vies, and all that good stuff. 2002 is approaching and what I need to do is make an exact copy of that database and clean all the data out of it. I know I will probably have to go through the table and clear them out but, as far as copying everything for that database into another database, is that possible?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
copy database
- Thread starter jvande
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question