New Releases – SQL Server Migration Assistant (SSMA)

We have shipped some updates to our migration tool – the SQL Server Migration Assistant (SSMA). It is now easier than ever to migrate to SQL Server 2005, 2008, and/or 2008 R2 from Access, Oracle, Sybase, and MySQL. You can even use SSMA to migrate from Access or MySQL to SQL Azure.   Customers andContinue reading “New Releases – SQL Server Migration Assistant (SSMA)”

CTP of SP2 for SQL Server 2008 is now available

SQL Server 2008 will soon have a new service pack – SP2. SQL Server service packs go through a CTP (aka beta) cycle prior to release. The CTP of SP2 is now available for you to download and test. This is only the pre-release version, so only use it for testing.   ·         SQL ServerContinue reading “CTP of SP2 for SQL Server 2008 is now available”

Checklist for upgrading to a new version of SQL Server

Here is the basic process for a full version upgrade (such as 2000 to 2008) of the SQL Server engine. The steps will be different for RS or AS. I did not include all the details of variations such as replication, mirroring, log shipping, full-text search, or clustering. They are covered in the white paperContinue reading “Checklist for upgrading to a new version of SQL Server”

x64 Windows – Upgrade from 32bit SQL Server to 64bit SQL Server

Many people are now upgrading from 32bit to 64bit SQL Servers. Most of you have a match between your operating system and your SQL Server platform. For example, most of you install a 32bit SQL Server on 32bit Windows, and if you have the x64 platform of Windows, you usually install the x64 SQL Server.Continue reading “x64 Windows – Upgrade from 32bit SQL Server to 64bit SQL Server”