Because of the limitations of SQL Server in that regard I picked up the book Real World SQL Server Administration with Perl.
http://www.apress.com/book/bookDisplay.html?bID=171 It's a pretty good book. I used it to write a script to write out all of the tables, stored procs, triggers, functions, and views from our production databases so they could be stored in version control. It isn't quite what you want but I'd be happy to send it to you if it would help in any way. Melissa On 10/31/06, Matthew Jarvis <[EMAIL PROTECTED]> wrote:
Quentin Hartman wrote: > 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! > > Any thoughts or recommendations would appreciated! > Quentin- I asked around to my MS cronies and I'm afraid to say that so far DTS is about the best they could come up with.... Matthew S. Jarvis IT Manager Bike Friday - "Performance that Packs." www.bikefriday.com 541/687-0487 x140 [EMAIL PROTECTED] _______________________________________________ EUGLUG mailing list [email protected] http://www.euglug.org/mailman/listinfo/euglug
_______________________________________________ EUGLUG mailing list [email protected] http://www.euglug.org/mailman/listinfo/euglug
