Sunday, September 27, 2009

SSMA Links Listing

In this section I will list down all the interesting and useful links on the internet on SSMA and SQL Server migration. I will try to update this frequently with new links.


SQL Server 2008 Migration Assistants
Downloads
SSMA 2008 for Oracle
SSMA 2008 for Oracle automates the end to end database migration process from Oracle to SQL Server 2008. It performs assessment, schema migration, data migration and validation of migrated database objects.


SSMA 2008 for Sybase ASE
SSMA 2008 for Oracle automates the database migration process from Sybase ASE to SQL Server 2008. It performs assessment, schema migration, data migration and validation of migrated database objects.


SSMA 2008 for Access
SSMA 2008 for Oracle automates the database migration process from Access to SQL Server 2008. It converts Access database objects to SQL Server database objects and performs the data migration. It supports Access 97 - Access 2007 databases.


SSMA 2008 for Sybase PowerBuilder Applications
SSMA 2008 for Sybase PowerBuilder Applications is a tool that cuts the effort, cost, and risk of migrating PowerBuilder Applications designed for Sybase ASE to SQL Server 2008.

SSMA 2008 for MySQL v1.0 CTP1
Microsoft SQL Server Migration Assistant (SSMA) 2008 is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2008 and SQL Azure.


SQL Server 2005 Migration Assistants Downloads
SSMA 2005 for Oracle
SSMA 2005 for Oracle automates the database migration process from Oracle to SQL Server 2005.

SSMA 2005 for Sybase ASE
SSMA 2005 for Sybase ASE automates the database migration process from Sybase ASE to SQL Server 2005.

SSMA 2005 for Access
SSMA 2005 for Access automates the database migration process from Access to SQL Server 2005.

SSMA 2005 for MySQL v1.0 CTP1
Microsoft SQL Server Migration Assistant (SSMA) 2005 is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2005.


SQL Server Migration Solutions Center

SQL Server Migration QuickStart

SSMA Forums
SQL Server Migration Forum

microsoft.public.sqlserver.migrationassistant

Webcasts

SQL Server 2008 for Oracle DBA

Migration Whitepapers

Migrating to SQL Server 2008
Guide to Migrating from Oracle to SQL Server 2008

Guide to Migrating from Sybase ASA to SQL Server 2008

Guide to Migrating from Sybase ASE to SQL Server 2008

Guide to Migrating from MySQL to SQL Server 2008

Guide to Migrating from Informix to SQL Server 2008

Migrating to SQL Server 2005

Guide to Migrating from Oracle to SQL Server 2005 using SSMA

Guide to Migrating from Sybase ASE to SQL Server 2005 using SSMA

Migrating from MySQL to SQL Server 2005

DB2 to SQL Server Migration Guide

Guide to Migrating from Microsoft Access to SQL Server 2005


Solution Guides
Solution for Migrating from Oracle on UNIX to SQL Server on Windows

Solution Guide for Sybase/UNIX to SQL Server

SSMA Knowledgebase

SSMA Conversion Errors and Messages Reference

SAP on SQL Server
Running SAP Applications on SQL Server Blog

SAP with Microsoft SQL Server 2008 and SQL Server 2005 Whitepaper

SAP OS/DB Migration to SQL Server - FAQ

Siebel on SQL Server
Siebel on SQL Server 2008 Whitepaper

How to Articles

Migration to SQL Server Express using SSMA Oracle PDF

Tuesday, September 8, 2009

SQL Server 2008 Migration Whitepapers

Microsoft has recently released whitepapers which help to migrate from other databases to SQL Server 2008.

Guide to Migrating from Oracle to SQL Server 2008
This white paper explores challenges that arise when you migrate from an Oracle 7.3 database or later to SQL Server 2008. It describes the implementation differences of database objects, SQL dialects, and procedural code between the two platforms. The entire migration process using SQL Server Migration Assistant (SSMA) 2008 for Oracle is explained in depth, with a special focus on converting database objects and PL/SQL code.

Guide to Migrating from Sybase ASA to SQL Server 2008
This white paper explores challenges that arise when you migrate from a Sybase Adaptive Server Anywhere (ASA) database of version 9 or later to SQL Server 2008. It describes the implementation differences of database objects, SQL dialects, and procedural code between the two platforms.

Guide to Migrating from Sybase ASE to SQL Server 2008
This white paper covers known issues for migrating Sybase Adaptive Server Enterprise database to SQL Server 2008. Instructions for handling the differences between the two platforms are included. The paper describes how SQL Server Migration Assistant, the best tool for this type of migration, can help resolve various migration issues.

Guide to Migrating from MySQL to SQL Server 2008
In this migration guide you will learn the differences between the MySQL and SQL Server 2008 database platforms, and the steps necessary to convert a MySQL database to SQL Server.

Guide to Migrating from Informix to SQL Server 2008
This white paper explores challenges that arise when you migrate from an Informix 11 database to SQL Server 2008. It describes the implementation differences of database objects and procedural code between the two platforms. Emulation of system functions is also discussed.

You can download these whitepapers from here.