SQL Server Migration Assistant v5.0 (On-Premise or Azure) for Oracle, Sybase, MySQL and Microsoft Access databases

Migrate from Sybase, Oracle, MySQL and Microsoft Access to SQL Azure and SQL Server with ease! Microsoft announced today the release of SQL Server Migration Assistant (SSMA) v5.0, a family of products to further simplify the user experience in automating the migration of Oracle, Sybase, MySQL and Microsoft Access databases to SQL server or SQL Azure.

In this release, SSMA family of products has been improved to further to reduce the cost and the risk of migration from Sybase, Oracle, MySQL and Microsoft Access. Our recent SSMA survey showed that 94% of SSMA downloader’s would recommend the tool to others. SSMA products are available for freedownload and are supported for free over email.

In recent months, there has been an uptick in migration to SQL Azure and/or SQL Server, Microsoft has observed more than 8,000 downloads/month of SSMA family of products in recent months. Dollar Thrifty Auto GroupPEMEXEli LilyLockheed MartinCSR LimitedFlorida Department of EducationForest OilThe Wyoming Department of Health Vital Statistics Services ProgramLandratsamt LandshutHorowhenua District Council, and Volvo Aero are just a few of the customers that have downloaded and used the SQL Server Migration Assistant toolkit to migrate to Microsoft SQL Server.

· What’s New in this Release? With this wave of release, customers can now migrate to any edition of SQL Server including the free Express edition.

 

Migrating To:

Migrating From:

Using SSMA Tool:

SQL Server all editions (2008 R2, 2008, 2005, “Denali”)

SQL Azure

Sybase SSMA for Sybase

√ (New in SSMA 5.0)

Oracle SSMA for Oracle

MySQL SSMA for MySQL

Access SSMA for Access

  • Support for migrating to SQL Server “Denali”
  • Multi-thread data migration for improved scale and performance.
  • Globalization support for migrating non-English databases to SQL Server.
  • Support for installation for SSMA Extension Pack on clustered SQL Server environments.
  • Sybase migration enhancements:
    • Support for migration to SQL Azure
    • Extended data access connectivity to Sybase ASE ADO.NET and ASE ODBC providers
    • Support for conversion of case sensitive Sybase database to case sensitive SQL Server
    • Extended support for conversion of Non-ANSI joins for DELETE and UPDATE statements
    • Removed dependency on separate SYSDB database on target SQL Server
  • Report use of Oracle’s User Defined Type in the database object and inside PL/SQL

Free Downloads:

1. SSMA for Access v5.0

2. SSMA for MySQL v5.0

3. SSMA for Oracle v5.0

4. SSMA for Sybase v5.0

Customers and partners can provide feedback or obtain free SSMA product support from Microsoft Customer Service and Support (CSS) at ssmahelp@microsoft.com.

Resources:

SSMA Team Blog: http://blogs.msdn.com/b/ssma

SQL Server Migrations Page: http://www.microsoft.com/sqlserver/en/us/product-info/migration.aspx

MSDN Forum: http://social.msdn.microsoft.com/Forums/en-US/sqlservermigration

Feedback/Product Support: ssmahelp@microsoft.com

Read the rest @> SQL Server Migration Assistant v5.0 is now available – SQL Server Team Blog – Site Home – TechNet Blogs

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.
 
Comments

No comments yet.

Leave a Reply

You must be logged in to post a comment.

 
Call Agile IT Now

(619) 292-0800

×
Visit Agile IT
Agile IT Office


Agile IT Headquarters
West Coast Sales Office
4660 La Jolla Village Drive, Suite 500
San Diego, CA 92122

Directions >


Network Operations & Support Center
4891 Pacific Highway, Suite 105
San Diego, CA, 92110

Directions >


North East Sales Office
250 Pehle Avenue, Suite 200
Saddle Brook, New Jersey


South East Sales Office
2202 N. West Shore Blvd
Tampa, Florida


Midwest Sales Office
60 E. Rio Salado Parkway, Suite 900
Tempe, Arizona
×
Intune Webcast by Agile IT

×
Intune Subscription Pricing

×
This Guy That Guy - Microsoft InTune Lighter Side

×
Compare Office 365 Subscription Pricing

×
Office 365 Webcast by Agile IT

×
Office 365 Success Stories

Microsoft Office 365 is at the forefront of productivity. For organizations of all sizes, Office 365 unites the familiar Microsoft Office desktop applications with the power of our most trusted productivity servers, into one connected online solution. No matter if you’re an entrepreneur just starting out or a multinational corporation connecting your employees across the globe, the best productivity tools are at your fingertips.

State of Minnesota – The executive branch of the State of Minnesota is made up of more than 70 agencies and employs 35,000 people. The State Office of Enterprise Technology (OET) provides services that improve government through the effective use of information technology. In 2010, OET decided to move the entire executive branch to the cloud-based services of Microsoft Office 365. With a hosted enterprise solution, IT staff can provide a highly reliable and secure platform while decreasing administration and costs.

Click here
to view case study.

Patagonia – Patagonia, a global provider of outdoor apparel and gear wanted a new solution for unified communications to help employees around the world work better together. The IT staff also needed to upgrade its aging messaging solution. Based on a pilot test of Office 365, Patagonia expects employees to communicate more effectively and make better design decisions. Patagonia also believes Office 365 will help it reduce IT costs, improve business continuity, and support its environmental initiatives.

Click here
to view case study.

Imagination Yoga – Imagination Yoga, which brings the benefits of yoga to children’s classrooms, struggled with communication among its owners. By adopting Microsoft Office 365, the company gained mobile access to email and calendar information, shared workspaces, and a centralized document repository. Imagination Yoga now runs more efficiently, can be more responsive, and is able to better focus on its mission to bring yoga to more children.

Click here
to view case study.

Traveler’s Haven - Travelers Haven is growing rapidly and wants to better coordinate employee activities. The company is testing Microsoft Office 365 and already finds it exceptionally useful in improving efficiency and communicating with remote employees. Once the whole staff is using Office 365, Travelers Haven expects to save 30 hours a day, avoid U.S.$100,000 annually in IT costs, and feel comfortable opening new offices around the United States.

Click here
to view case study

×
Intune Deep Dive

×
Active Directory (AD)
Active Directory (AD) is a directory service created by Microsoft for Windows domain networks. It is included in most Windows Server operating systems.
An AD domain controller authenticates and authorizes all users and computers in a Windows domain type network—assigning and enforcing security policies for all computers and installing or updating software.
×
SAML Endpoints
SAML 2.0 is a standard which ensures interoperability across identity providers and gives enterprises the freedom to choose a cloud providers without needing to worry about additional management.
Many Cloud services are SAML Endpoints. Some of the most well-known are are:
  • Google
  • Yahoo
  • Salesforce.com
  • Remedy
  • ZenDesk
  • Zoho
  • Zimbra
  • CIsco Webex
  • Box.com

and many more.

×