Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Setup & Upgrade

Upgrade SQL 2000 SBS to SQL 2005 64 Bit

I am in the beginning of upgrading a SQL 2000 DB on a Small business server to a 64 bit 2005 DB on a new box. Is my best method of upgrading to use the "copy" DB function in 2005? If so, what do I need to do to install the management tools on the 2000 box - since this is a 32 bit edition, and I have the 64 bit media?
[328 byte] By [KevinZ] at [2007-12-24]
«« MSDN Premium Subscrpition & Windows 2003 and Sharepoint license questions
»» Were is _2_RTL_x86_enu_Visual_Database_Tools_Core.cab? VS2005
# 1

You could take a backup on the 2000 server and restore it on your 2005 server. Create the same users on the new server that where on the old server. After restore run sp_change_users_login 'report' in Management studio or Query Analyzer. If names come up in the list you need to map the users in the database to the users in the 2005 server. Create a script that runs sp_change_users_login 'update_one', 'user1' , 'user1'.

See Books Online (local helpfile) for details

ipconfig at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...
SQL Server
SQL Server Setup & Upgrade

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified