migration from SQL 2000 to SQL 2008

iccsi () writes:

I am working on to migrate my SQL 2000 database to SQL 2008.
I use SSMS to connect 2 SQL Servers and want to backup SQL 2000
database and restore on SQL 2008.

I just realized that I only can access SQL 2000 server when I backup
and I only can access SQL 2008 when I want to restore.

I am looking for a method that I can backup SQL 2000 database to let
2008 access to restore.

Any information is great appreciated,

I'm not sure what your problem is. From one query window you run the BACKUP
command on SQL 2000, and from another query window you run the restore
command.

If you want all in one script, you can set up a linked server on the
SQL 2008 instance to the SQL 2008 instance. Then you can say:

EXEC('BACKUP DATABASE ') AT MySQL2000instance

(You must run this from SQL 2008, because EXEC AT is not available in
SQL 2000.)

Erland Sommarskog, SQL Server MVP,

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sql...14207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sql...95970.aspx