Move Sql 7 databases to SQL 2000 server on different network

What would be the best/easiest procedure to move a few SQL 7 databases to a
SQL 2000 server that is running on a different network?It's easy enough to back them up, copy the backup files to
the SQL2000 server, and restore there.
If you have reliable network connectivity, you could skip
the copy step and restore directly from the backup files
on the remote server by specifying the files' UNC names.
You could also backup to the remote server, and then
restore from the backup files locally on the other server.
Linchi
>--Original Message--
>What would be the best/easiest procedure to move a few
SQL 7 databases to a
>SQL 2000 server that is running on a different network?
>
>.
>|||| What would be the best/easiest procedure to move a few SQL 7 databases to
a
| SQL 2000 server that is running on a different network?
--
I would backup the SQL 7 database, ship the backup file to the SQL 2000
server and restore it there.
Hope this help,s
--
Eric Cárdenas
SQL Server support|||>--Original Message--
>| What would be the best/easiest procedure to move a few
SQL 7 databases to
>a
>| SQL 2000 server that is running on a different network?
>--
>I would backup the SQL 7 database, ship the backup file
to the SQL 2000
>server and restore it there.
Make sure that both servers are using the same settings
for Locale, Collation and case sensitivity.
Dave.|||> Make sure that both servers are using the same settings
> for Locale, Collation and case sensitivity.
Just to expand a bit:
They don't *have* to be on the same collation setting as in SQL2K, you can have different collations
between different databases. However, that might cause problems if the code isn't written to handle
this, so I agree that this is a good idea.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:06fe01c3c3b9$aa8a1cd0$a501280a@.phx.gbl...
> >--Original Message--
> >| What would be the best/easiest procedure to move a few
> SQL 7 databases to
> >a
> >| SQL 2000 server that is running on a different network?
> >--
> >I would backup the SQL 7 database, ship the backup file
> to the SQL 2000
> >server and restore it there.
> Make sure that both servers are using the same settings
> for Locale, Collation and case sensitivity.
> Dave.