SQL Server Migration Assistant (SSMA) Team's Blog
How-to articles, tips-and-tricks, and guidelines for migrating from Oracle/Sybase/MySQL/Access to SQL Server and SQL Azure
Translate This Page
Translate this page
Access Data Migration
Access Migration Assessment
Access Migration Error
Access Migration Planning
Access Schema Conversion
Migrate from Access
Migrate from MySQL
Migrate from Oracle
Migrate from Sybase
MySQL Data Migration
MySQL Error Messages
MySQL Migration Assessment
MySQL Migration Planning
MySQL Schema Conversion
Oracle Data Migration
Oracle Migration Assessment
Oracle Migration Error
Oracle Migration Planning
Oracle Schema Conversion
SQL Azure Migration
SQL Server "2014"
SQL Server "Denali"
SSMA Sybase ASA SQL Server Adaptive Server Anywhere
Sybase Data Migration
Sybase Migration Assessment
Sybase Migration Planning
Sybase Schema Conversion
Testing Database Migration
Browse by Tags
SQL Server Migration Assistant (SSMA) Team's Blog
oracle schema conversion
Tagged Content List
Microsoft SQL Server Migration Assistant (SSMA) v5.3 is now available.
SSMA simplifies database migration process from Oracle/Sybase/MySQL and Microsoft Access to SQL Server and SQL Azure. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing to reduce cost and reduce...
15 May 2014
Microsoft SQL Server Migration Assistant (SSMA) 5.2 is Now Available
Automating Database Migration to SQL Server 2012 SQL Server Migration Assistant (SSMA) v5.2 is now available. SSMA simplifies database migration process from Oracle/Sybase/MySQL and Microsoft Access to SQL Server and SQL Azure. SSMA automates all aspects of migration including migration assessment...
30 Jan 2012
Converting Oracle Sequence to SQL Server "Denali"
Updated 2/7/2012 Jiafei Yuan - Microsoft SQL Server Migration Assistant (SSMA) for Oracle v5.2. The information provided below is still valid for SSMA for Oracle v5.2, but SQL Server "Denali" is changed to 2012. Users should download the lastest SSMA for Oracle] One of the new feature in SQL Server...
12 Jul 2011
Emulating Records and Collections via CLR UDT
By Bill Ramos and Vishal Soni , Advaiya Inc. This blog covers how the SQL Server Migration Assistant (SSMA) for Oracle uses the SQL Server Common Language Runtime (CLR) User-Defined Types (UDT) for emulating Oracle Records and Collections. In this blog...
29 Jun 2011
Migrating Oracle ANYDATA to SQL Server
By Welly Lee, Pinaki Bag, and Jayakumar Tanneru. Oracle has an object data type called anydata . This data type supports wide range of data types. For example when creating a table with a column defined as anydata type, the column can store many types of data from string to numeric . SSMA does not...
21 Jun 2011
Migrating Oracle Materialized View to SQL Server
By Gowri Shanker and Welly Lee. This blog post discusses approaches to migrate Oracle Materialized View to SQL Server. We compare Materialized View with SQL Server Indexed View, discuss scenarios supported by Indexed View and provide suggestions you can consider for the non-supported scenarios. ...
20 Jun 2011
Migrating Oracle to SQL Server using SSMA–Error O2SS0041 Illegal Identifier
When converting Oracle schema to SQL Server using SSMA, you may encounter an error when your table contains a DATE column with default value. This blog post describes the reason for the error and what you should do when you encounter this error. Consider the following example -- Oracle source table:...
26 May 2011
Converting Oracle UDT to SQL Server TVP
Oracle supports User Defined Type (UDT) which include object type and collection. This data type is not supported in SQL Server and SSMA does not support conversion of Oracle UDT. You may consider using SQL Server TVP when migrating your Oracle database to SQL Server. The following provides use scenarios...
25 May 2011
Improving Performance of SSMA Migration Assessment
When performing migration assessment for a large schema (with thousands of objects), you can use the following to help improve performance: Run SSMA application on hardware with x64 bit Windows and memory of at least 4 GB. Force load the schema information prior performing migration assessment...
25 May 2011
SSMA @TechEd Video
SSMA session from North America TechEd is now available from Channel 9 .
14 May 2011
Migrating Oracle to SQL Server Using SSMA - Emulating Oracle Package Variables
By Bill Ramos and Vishal Soni , Advaiya Inc. Oracle supports encapsulating variables, types, stored procedures, and functions into a package. When you convert Oracle packages, you need to convert: Procedures and functions - both public and private Variables Cursors Initialization...
12 May 2011
Migrating Oracle to SQL Server using SSMA–Error O2SS0293: Columns list in set clause cannot be converted
This blog post describes SSMA error message when converting Oracle PL/SQL UPDATE statement with column group assignment. Oracle PL/SQL allows you to perform multi column update through sub-query. Consider the following example: CREATE TABLE ACCOUNT ( ACCOUNT_ID NUMBER NOT NULL, ACCOUNT_OWNER VARCHAR2...
10 May 2011
Saving Comments During Migration
During migration to SQL Server, you may find that the source database schema contains some comments to describe the schema. This can be as a comment within programming code (such as Oracle PL/SQL) in procedure, function, package, view or as a comment that is part of the table/ column schema. SQL Server...
17 Feb 2011
Video: Converting Schema to SQL Server
This video walks you through the schema conversion of SSMA, including an example on how to resolve issue during conversion Check out the other videos in this series: Introduction to SSMA Planning Your Database Migration Analyzing Database Using SSMA Converting Schema to SQL...
5 Feb 2011
A Foreign Affair
You may run into issue when using SSMA to connect to Oracle database containing foreign characters (non-ASCII characters) in its schema. In the example below, we have an Oracle database containing a table with Japanese name: The issue is caused by the Oracle client provider not able to process...
4 Jan 2011
A Curious Case of NUMBER truncation
Oracle's FLOAT may truncate a float number beyond its binary digit limit. For example, execute the following in Oracle: DECLARE testvar FLOAT(5); BEGIN Testvar := 123.45; DBMS_OUTPUT.put_line(to_char(testvar)); END; The statement will return 120 as the number 123.45 is rounded...
29 Oct 2010
How To Convert Individual Statement Using SSMA
You can use SSMA to convert a statement (such as PL/SQL) into T-SQL statement using SSMA. This functionality can be used, for example, to convert embedded SQL statement inside an application that connects to the database. Use the following steps to convert individual statement: Open SSMA tool...
21 Sep 2010
Page 1 of 1 (17 items)
© 2014 Microsoft Corporation.
Privacy & Cookies