Migration Assistant

Article

One of my client’s requirements is to migrate and consolidate his company departments’ databases to SQL Server 2008. As I know the environment, they are using MySQL , MS-Access and SQL Server with different applications. Now the company has decided to have a single dedicated SQL Server 2008 database server to host all the applications. So there are a few things to do to upgrade and migrate from MySQL and MS-Access to SQL Server 2008. For the migration task, I found the SQL Server Migration Assistant 2008 (SSMA 2008) is very useful which reduces the effort and risk of migration. So in this tip, I will do an overview of SSMA 2008.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2011-02-07

3,206 reads

Read the latest Blogs

Visit the forum

Question of the Day

The "ORDER BY" clause behavior

Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:

create table t1 (id int primary key, city varchar(50));

insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);

If we execute the following query, how will the records be sorted in both environments?

select city

from t1

order by city;

See possible answers

Migration Assistant

SQL Server Migration Assistant 2008 (SSMA)

Blogs

Redgate Summit Comes to the Windy City

Non-Functional Requirements

Techorama 2024 – Slides

Forums

Error while an ADF pipeline runs stored procedures against Azure SQL Server MI

Clear Trace - Asking for SQL Server 2008

get all txt files $filenameAndPath = code please help

Question of the Day

The "ORDER BY" clause behavior