?
Solved

Migrate SQL Server 2005 x86 to SQL Server 2008 x64 in default instance

Posted on 2008-10-09
2
Medium Priority
?
1,168 Views
Last Modified: 2008-10-28
Hi

We need to migrate a SQL Server 2005 x86, running in a Windows Server 2003 R2 x64 to a SQL Server 2008 x64.

Thanks in advance
0
Comment
Question by:zdavidlnx
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Expert Comment

by:bcsql
ID: 22679748
You want to change your default install of SQL 2005 from x32 to x64? you have reinstall.
1) detach databases - alluser dbs, model and msdb.
2) script logins - and jobs just in case
http://support.microsoft.com/kb/918992/
3) save db files and scripts
4) unintall SQL
5) install sql x64
6) attach dbs
7) re attached dbs once files are in correct place.
8) run scripts for logins and jobs if msdb is not reattached.
0
 
LVL 20

Accepted Solution

by:
Marten Rune earned 750 total points
ID: 22684882
Sorry bcsql, not entirely correct!
For clarification, step 3 for bcsqq does not include the system databases, So step 2 above is crucial since you must reinstall every job, all accounts and preserve their passwords.
Otherwise lbcsql is correct. But also check that all databases dont use custom extended stored procedures, or worse, is still using DTS packages (they can be run under sql2005, but not edited).
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question