Sure thing.
I do as much work as I can in SQL Server through Query Analyzer rather
than Enterprise Manager, so here are the scripts I use for backing up
and restoring individual databases.
USE master
EXEC sp_addumpdevice 'disk', 'DatabaseBackup', '\\Path\to\database\file.bak'
BACKUP DATABASE Da
On 10/31/06, M. Bitner <[EMAIL PROTECTED]> wrote:
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 hap
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,
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
proced
can you build what you need from freetds?
http://www.freetds.org/
Haven't used it with SQLServer but it works well with sybase, and
makes the painful bits of dealing with Transact-SQL tolerable.
(MS-SQL is a fork of Sybase and the two are supposed to be more
similar than different)
On 10/30/06,
http://davidhayden.com/blog/dave/archive/2006/01/13/2692.aspxor even
http://mdid.org/mdidwiki/index.php?title=How_to_export_data_from_SQL_Server_2000_to_XML if you re-imported,but I'm guessing you want table definitions too.or: Can you restore a table backup to a differently-named table?
sorry, t
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 w
