October 4, 2002 at 3:17 pm
I currently run a SQL Server 7 on an NT machine (SBS 4.5). We are upgrading to a new Server with Win2K and SQL Server 2000. What is the easiest/best way to migrate my entire DB over to the new server.
Small Business Server 4.5 does provide replication or upgrading to SQL Server 2000.
October 4, 2002 at 4:11 pm
I think Backup and restore will work for the dbs. I'd do that. If you need logins, use DTS.
Steve Jones
October 4, 2002 at 4:17 pm
Thanks Steve.
No sweat with backing up from 7.0 and restoring to v.2000?
I do need logins and everything else, not familiar with DTS but I will research it.
October 4, 2002 at 5:19 pm
You can install sql 2000 in the server with sql 7 and then migrate everything to sql 2000 while you still have the db in sql 7.
October 4, 2002 at 5:42 pm
Sp_detach_db and sp_attach_db. Remeber to run sp_updatestats after upgrade db to the SQL Server 2000.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply