Migration SQLSERVER DB from one server to another Server

Hello,
How to migrate SQLSERVER DB from one server to another Server?
We are planning from Compaq server to Dell and vice versa?
Thx.
-SeenaBackup all databases from one server and restore on the other.
I think BOL has info on how to do this for system databases - if not just do a search.

Also look at detach/attach.

Worth reading up about system databases first.|||Hello,
It is the same as the other member of dBforums explained to you. It is so simple, you need only to backup the database. If you are using MS SQL Server 2000, you'll have to choose the database:
- right click
- all tasks
- backup database
- choose the device to which you want to copy (tape/disk)

Then on the other PC, create these databases manually and:
-choose the newly created DB
-right click
-all tasks
-restore database
-choose the source

Otherwise, you can use the DTS service which is available in SQL Server 2000.

it is so simple to use.

Take cares & good luck!

Alzebdeh
Originally posted by sqlserverdb
Hello,
How to migrate SQLSERVER DB from one server to another Server?
We are planning from Compaq server to Dell and vice versa?
Thx.
-Seena|||The easiest, if you have both computer on-line, is to Detach the databases
and copy the MDF and LDF files into the new server, then attach those files
into new SQl.

"Alzebdeh" wrote in message
news:2441325.1043640789@.dbforums.com...
> Hello,
> It is the same as the other member of dBforums explained to you. It is
> so simple, you need only to backup the database. If you are using MS SQL
> Server 2000, you'll have to choose the database:
> - right click
> - all tasks
> - backup database
> - choose the device to which you want to copy (tape/disk)
> Then on the other PC, create these databases manually and:
> -choose the newly created DB
> -right click
> -all tasks
> -restore database
> -choose the source
> Otherwise, you can use the DTS service which is available in SQL
> Server 2000.
> it is so simple to use.
> Take cares & good luck!
> Alzebdeh
> Originally posted by sqlserverdb
> > Hello,
> > How to migrate SQLSERVER DB from one server to another Server?
> > We are planning from Compaq server to Dell and vice versa?
> > Thx.
> -Seena
> --
> Posted via http://dbforums.com (http://dbforums.com/)

Migration of database from MS SQL to Pervasive SQL and vice versa

Hi,
would to know what are the ways to migrate DB/copy tables
(1) from MS SQL to Pervasive SQL and
(2) from Pervasive SQL to MS SQL
Thank you.
Regards. SallyOriginally posted by sallypeh
Hi,
would to know what are the ways to migrate DB/copy tables
(1) from MS SQL to Pervasive SQL and
(2) from Pervasive SQL to MS SQL

Thank you.
Regards. Sally

From Pervasive to SQL Server works well through the Import / Export Wizard (and DTS), using Pervasive's ODBC or OLE DB.
I have not had any reason to try it the other way, but it should work too.

Cheers,
Robert