HomeDatabase News

New SQL Server Migration Assistant Releases Feature Support for MySQL and Updates for Other Databases

DatabaseJournal.com Staff
By DatabaseJournal.com Staff

Microsoft’s SQL Server Migration Assistant (SSMA) is now available for MySQL; and the existing Assistants for Oracle, Sybase, and Access have been updated to version 4.2. The SSMA toolkits were designed to make the complex process of manually migrating databases easier, which also reduces the accompanying time, cost, and risks. SSMA for MySQL v1.0 works with MySQL 4.1 and above; and is able to convert/migrate tables, views, stored procedures and functions, triggers, DML statements, and more. Both SSMAs for MySQL and Access also support simple and direct migration to SQL Azure. Some of the new features for SSMA v4.2 for Oracle, Sybase, and Access are:

  • Console support for automated DB assessment/DB migration/SQL syntax conversion for application migration
  • Support for client side and server side data migration for convenience
  • Support for migrating to SQL Server 2008 R2; and from the latest Oracle (11g R2), Sybase (15.5) and Access (2010) releases
DatabaseJournal.com Staff
DatabaseJournal.com Staff
Previous article
Tuning an IBM DB2 for z/OS Application: CPU Constraints
Next article
Replicate Databases, Reduce Transaction Latency, and More with Sybase Replication Server

Related Articles

Get the Free Newsletter!

Subscribe to Cloud Insider for top news, trends & analysis

Latest Articles

DatabaseJournal.com publishes relevant, up-to-date and pragmatic articles on the use of database hardware and management tools and serves as a forum for professional knowledge about proprietary, open source and cloud-based databases--foundational technology for all IT systems. We publish insightful articles about new products, best practices and trends; readers help each other out on various database questions and problems. Database management systems (DBMS) and database security processes are also key areas of focus at DatabaseJournal.com.

Advertisers

Advertise with TechnologyAdvice on Database Journal and our other IT-focused platforms.

Advertise with Us

Menu

Our Brands

Property of TechnologyAdvice.
© 2024 TechnologyAdvice. All Rights Reserved

Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.