Tried googling, but I guess I have the wrong terminology for MS
products.

Using PostgreSQL, or MySQL, if I wanted to tranfer a database from one
machine to another, I'd do a "dump" with a single command, such as:
mysqldump [databasename] > [path/filename]

Then I'd take the file generated and dump it back onto a new machine.

What's the process with MS SQL Server? Can someone point me in the
right direction to a webpage dealing with this?


--
[ Sugapablo ]
[ http://www.sugapablo.com <--music ]
[ http://www.sugapablo.net <--personal ]
[ sugapablo@12jabber.com <--jabber IM ]

Take a look at the BACKUP and RESTORE commands in SQL Server Books Online.

BACKUP DATABASE <dbName> TO DISK = '<path>'
RESTORE DATABASE <dbName> FROM DISK = '<path>'

Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine.
"Sugapablo" <russREMOVE@sugapablo.com> wrote in message news:slrnccrb4m.6g5.russREMOVE@dell.sugapablo.net. ..
Tried googling, but I guess I have the wrong terminology for MS
products.

Using PostgreSQL, or MySQL, if I wanted to tranfer a database from one
machine to another, I'd do a "dump" with a single command, such as:
mysqldump [databasename] > [path/filename]

Then I'd take the file generated and dump it back onto a new machine.

What's the process with MS SQL Server? Can someone point me in the
right direction to a webpage dealing with this?


--
[ Sugapablo ]
[ http://www.sugapablo.com <--music ]
[ http://www.sugapablo.net <--personal ]
[ sugapablo@12jabber.com <--jabber IM ]

"Sugapablo" <russREMOVE@sugapablo.com> wrote in message
news:slrnccrb4m.6g5.russREMOVE@dell.sugapablo.net. ..
> Tried googling, but I guess I have the wrong terminology for MS
> products.
>
> Using PostgreSQL, or MySQL, if I wanted to tranfer a database from one
> machine to another, I'd do a "dump" with a single command, such as:
> mysqldump [databasename] > [path/filename]
>
> Then I'd take the file generated and dump it back onto a new machine.
>
> What's the process with MS SQL Server? Can someone point me in the
> right direction to a webpage dealing with this?
>
>
> --
> [ Sugapablo ]
> [ http://www.sugapablo.com <--music ]
> [ http://www.sugapablo.net <--personal ]
> [ sugapablo@12jabber.com <--jabber IM ]


http://support.microsoft.com/default...&Product=sql2k

Simon

Hi

See http://support.microsoft.com/default...;en-us;Q314546 for the
various ways to move a database between two servers running SQL Server.

John

"Sugapablo" <russREMOVE@sugapablo.com> wrote in message
news:slrnccrb4m.6g5.russREMOVE@dell.sugapablo.net. ..
> Tried googling, but I guess I have the wrong terminology for MS
> products.
>
> Using PostgreSQL, or MySQL, if I wanted to tranfer a database from one
> machine to another, I'd do a "dump" with a single command, such as:
> mysqldump [databasename] > [path/filename]
>
> Then I'd take the file generated and dump it back onto a new machine.
>
> What's the process with MS SQL Server? Can someone point me in the
> right direction to a webpage dealing with this?
>
>
> --
> [ Sugapablo ]
> [ http://www.sugapablo.com <--music ]
> [ http://www.sugapablo.net <--personal ]
> [ sugapablo@12jabber.com <--jabber IM ]