I was recently working on learning various new stuff. I just would like to share very interesting resources here today. Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from any other data platform to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.
Here are few important resources links:
Microsoft SQL Server Migration Assistant (SSMA) Team’s Blog
One very front page of the blog, I noticed very interesting diagram – where it displays four database products. One can click on any of them to go to detail description of the same. Here is interesting Video regarding this tool.
- Planning Your Database Migration
- Analyzing Database Using SSMA
- Converting Schema to SQL Server
- Migrating Data Using SSMA
- Automating Database Migration Using SSMA Console Application
If you have any particular question or need help regarding migration – you can always reach out to me and I will do my best to help you.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
10 Comments. Leave new
As SQL Server becoming more popular day by day, requirement of such efficient migration tools is increasing. I think Microsoft should also focus on migration tools which would be helpful to migrate data from less popular RDBMS vendors. I remember that whenever I was asked to migrate data from most known vendors like Oracle, Sybase and MySql, I never felt any difficulty as there is lot of help available other then SSMA but when once I was asked to migrate from Top Speed. My first answer was a question. What’s that? And I found NO proper help in this regard.
Is there a option to migrate from Sql Server to MySQL using this tool??
Is it possible to convert all the views and stored procedure from mysql to SQL server using this product??
Help!
I have sql server 2008 r2 developer and oracle 10g on my pc. From the migration assistant I can connect to both computers I select the source and destination schema and database but the convert schema, migrate data, and create report buttons and menu items are ghosted out and do nothing when selected. I am not tring to copy a sys or system schema from oracle, just a simple schema. What am I doing wrong?
Any thoughts on moving an environment that was migrated from Oracle and still uses some of the Oracle functions/stored procedures stored in the ‘Sysdb’ database?
Hi pinal,
I have one dought,
this is Regarding to SSRS(Reporting Services)
How to set the parameter to readonly in report parameter
Ex:
I have two parameters
one is Group code and another one is Group type
Group type is readonly
Means After selection of Group Code,Group type will come to Edit mode(Selection is possible from that Group type parameter)
can me please tell me….
Sivaram
Can anyone Please tell me..How does SSMA identify the CURSOR as Static/Dynamic type and convert ..??
Praveen
Hi Dave,
i want to do migration from sql server 2008r2 to sql server 2017,could u pls suggest is there any automation tool to implement. pls reply ASAP.
There is no automation tool I am aware of. First you need to check if application team is going to support SQL 2017. If yes, then you need to choose if you want in-place upgrade or side by side. and then go from there.
We are going to work with parallel upgrade for many servers but my project requirement is pre-migration steps and post migration steps has to handled by automatic(even it has to take care of logins,jobs and users for selected databases) will it done by SSIS package or powershell script pls suggest us.