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.
Reference: Pinal Dave (https://blog.sqlauthority.com)
Many of us are tend to overlook simple things even if we are capable of doing complex work. In SQL Server 2008, inline variable assignment is available. This feature exists from last 3 years, but I hardly see its utilization. One of the common arguments was that as the project migrated from the earlier version, the feature disappears. I totally accept this argument and acknowledge it. However, my point is that this new feature should be used in all the new coding – what is your opinion?
The code which we used in SQL Server 2005 and the earlier version is as follows:
DECLARE @iVariable INT, @vVariable VARCHAR(100), @dDateTime DATETIME
SET @iVariable = 1
SET @vVariable = 'myvar'
SET @dDateTime = GETDATE()
SELECT @iVariable iVar, @vVariable vVar, @dDateTime dDT
GO
The same should be re-written as following:
DECLARE @iVariable INT = 1, @vVariable VARCHAR(100) = 'myvar', @dDateTime DATETIME = GETDATE()
SELECT @iVariable iVar, @vVariable vVar, @dDateTime dDT
GO
I have started to use this new method to assign variables as I personally find it very easy to read as well write.
Do you still use the earlier method to declare and assign variables? If yes, is there any particular reason or just an old routine? I am interested to hear about this.
Reference: Pinal Dave (https://blog.sqlauthority.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.
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.