Automating Database Migration to Microsoft SQL Server

Download this episode

Download Video

Description

Does your organization have Oracle,Sybase,MySQL or Access databases that you like to migrate to SQL Server or SQL Azure? Do you know that Microsoft offers a free tool to automate database migration? In this demo-heavy session,we examine how SQL Server Migration Assistant (SSMA) migrates other databases to SQL Server. Discover how the tool perform assessment to analyze complexity of the database to help you plan for migration. Explore how the tool map data types to the equivalent SQL Server’s and convert different SQL dialects inside function,procedure,triggers,and cursors to T-SQL. Learn how the tool emulates other database features not natively supported in SQL Server. Get a peek of what's being planned for SSMA in 2011. Come to this session to learn the ins-and-outs of database migration and understand how SSMA can save time and cost for your migration.
For more information, check out this course on Microsoft Virtual Academy:

Day:

1

Code:

DBI307

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.