Automating Database Migration to Microsoft SQL Server
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.