Migrar o SQL Server

Question

Posso migrar o banco de dados de 32 bits do SQL Server 2005 para o banco de dados de 64 bits do SQL Server 2008 sem muita complicação ou há algo em que preciso pensar primeiro?

    

Answer 1

• Faça o download e execute o Supervisor de atualização do SQL Server 2008
• Verifique se você está usando atualmente algum recurso preterido no SQL 2005 que pode ter sido descontinuado no SQL 2008, consulte Quais recursos preteridos estou usando?
• Veja o tópico Compatibilidade com versões anteriores dos recursos que você usa (Mecanismo, SSAS, SSRS, SSIS, Replication) e ver se há algo que se aplique à sua implantação
• Defina sua estratégia de upgrade: lado a lado ou no local
• Leia e analise as Considerações sobre como atualizar o mecanismo de banco de dados . muito menos siga a lista de verificação rápida nesse tópico:

• When upgrading from a 64-bit edition of SQL Server to a 64-bit edition of SQL Server 2008, you must upgrade Analysis Services before you upgrade the Database Engine.
• Back up all SQL Server database files from the instance to be upgraded, so that you can restore them, if it is required.
• Run the appropriate Database Console Commands (DBCC) on databases to be upgraded to ensure that they are in a consistent state.
• Estimate the disk space that is required to upgrade SQL Server components, in addition to user databases. For disk space that is required by SQL Server components, see Hardware and Software Requirements for Installing SQL Server 2008 R2.
• Ensure that existing SQL Server system databases - master, model, msdb, and tempdb - are configured to autogrow, and ensure that they have sufficient hard disk space.
• Ensure that all database servers have logon information in the master database. This is important for restoring a database, as system logon information resides in master.
• Disable all startup stored procedures, as the upgrade process will stop and start services on the SQL Server instance being upgraded. Stored procedures processed at startup time might block the upgrade process.
• Stop Replication and make sure that the replication log is empty.
• Upgrading an instance of the SQL Server 2000 Database Engine retains the configuration value for max worker threads. However, we recommend that you change the max worker threads value to 0 before upgrading, to let the Database Engine calculate the optimal number of threads. For more information, see max worker threads Option in SQL Server Books Online.
• Quit all applications, including all services that have SQL Server dependencies. Upgrade might fail if local applications are connected to the instance being upgraded.
• If you utilize Database Mirroring, see How to: Minimize Downtime for Mirrored Databases When Upgrading Server Instances in SQL Server Books Online.

    

Answer 2

Não há muito com o que se preocupar. Você pode separar o banco de dados, mover e reconectar ou fazer backup e restauração. O aplicativo que usa o db suporta 2008? Se não, deixe-o no modo de compatibilidade 90.