Matthew Jarvis <> wrote: > I'm posting this on behalf of an associate... > > "I'm needing to copy all of the contents of one MS SQL 2000 server to > another. In MySQL, I'd just "mysqldump --all-databases" and get on > with life. However, there doesn't seem to be an equivalent tool for > MS SQL that will do everything on the server and get the stored > procedures and auth info and whatnot. The DTS built in to MS SQL 2000 > could work, but that requires explicitly naming each database I want > to copy, which won't be feasible in the long run because the number > of databases on this machine is constantly growing. All the > commercial third-party applications I've looked at are similarly > database-centric, with no good way to "give me everything" in any > sort of scriptable way. I want a very stupid tool, and everything > I've found tries to be too smart! "
Do a backup and you get exactly what your looking for. You can then restore from that on the new server. Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 "Our scientific power has outrun our spiritual power. We have guided missiles and misguided men." Dr. Martin Luther King Jr. http://spaces.msn.com/members/srussell/ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.408 / Virus Database: 268.13.17/505 - Release Date: 10/27/2006 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
