Database News

Top Articles

Hover to load posts
Features

Top Articles

Hover to load posts
Scripts

Top Articles

Hover to load posts
Mysql

Top Articles

Hover to load posts
MS SQL

Top Articles

Hover to load posts
Oracle

Top Articles

Hover to load posts
MS Access

Top Articles

Hover to load posts
DB2

Top Articles

Hover to load posts
PostgreSQL

Top Articles

Hover to load posts
SAP

Top Articles

Hover to load posts
PHP

Top Articles

Hover to load posts
Forums Forums

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

Written By

Aug 16, 2010

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

Recommended for you...

MySQL

Best Certifications for Database Administrators

We highlight some of the best certifications for database administrators. Learn about the top DBA certifications.

Ronnie Payne

Oct 14, 2022

Database News

Become More Efficient at Writing TSQL by Creating Code Snippets

A TSQL code snippet is a set of code that performs a task that can easily be placed in your TSQL code using SQL Server Management Studio (SSMS). Snippets

Gregory Larsen

Jun 30, 2021

Database News

Line Numbers in SQL Server Management Studio

Have ever tried to debug a chunk of TSQL code (like a stored procedure) and found yourself trying to figure out which TSQL statement is at a particular

Gregory Larsen

Sep 4, 2018

Database News

Couchbase Raises $60 Million to Fuel NoSQL Database Efforts

It takes a lot of money to build a database company in an industry dominated by giants like Oracle, Microsoft and IBM. It's a lesson that open-source

Sean Kerner

Jun 30, 2014

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.

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

DatabaseJournal.com Staff

Recommended for you...

Company

Categories