August 4, 2003 at 11:51 am
i currenntly have sql server7.0 and sqlserver2000 on two
different boxes.
The sql server is a more controled environment and i have
been asked to move databases from sql server7.0 to the
2ksqlserver.
the 7.0 databases are being accessed by several webapps
and a windowbased application.
how do i go about this without bringing about issues for
the apps currently using 2ksqlserver
and what would be a good back-out plan
[font="Comic Sans MS"][/font]It is what it is.
August 4, 2003 at 2:19 pm
See:
Upgrading Databases from SQL Server 7.0
in Books Online or here in MSDN
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_upgrade_6nqr.asp
August 4, 2003 at 2:29 pm
Take the backup on SQL 7.0 and restore it on SQL 2000. Make sure the drive letters matching. Depending on how the webapps connecting your server either by the server name/ IP address, make sure developers are aware of it. Also make sure to configure dsn on your server if any. Use sp_change_users_login to fix the logins
Shas3
August 4, 2003 at 4:13 pm
drive letters don't need to match. Use the WITH MOVE syntax for restore.
Steve Jones
August 11, 2003 at 9:32 am
a big thanks to every one that has responded
[font="Comic Sans MS"][/font]It is what it is.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply