SQL SERVER – SQL Server Migration Assistant (SSMA) – Tools – Video – Download

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.

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 (http://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 (http://blog.SQLAuthority.com)

7 thoughts on “SQL SERVER – SQL Server Migration Assistant (SSMA) – Tools – Video – Download

  1. 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.

    Like

  2. 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?

    Like

  3. 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?

    Like

  4. 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

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s