The new version of SSMA - SSMA 5.2 provides the following major enhancements:
Launch the download of the SSMA for Oracle.
Launch the download of the SSMA for Sybase.
Launch the download of the SSMA for MySQL.
Launch the download of the SSMA for Access.
You use SSMA 5.2 to migrate to any edition of SQL Server. In the overview section of www.microsoft.com/.../details.aspx
we have mentioned "SSMA for Oracle v5.2 is designed to support migration from Oracle 7.3 or later version to all edition of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012."
I am sorry for the late reply. You can use the help section of the tool and you can also download the whitepapers from www.microsoft.com/.../details.aspx
Do SSMA v5.2 support migrations from Sybase ASA 12.0 or higher?
I am really sorry but unfortunately we never had Sybase ASA on our plans for SSMA. The plan is still intact and we still support migration from Sybase ASE 11.9 onwards with the latest version of SSMA for Sybase www.microsoft.com/.../details.aspx
But I still see a silver lining in your case since your need is to migrate only schema and data I guess you can use a Linked Server to great advantage. The syntax between Sybase and MS SQL Server don’t differ much as they share the same DNA. Below are the providers that you can use to setup a linked server from SQL Server to Sybase ASE and then use queries to pull data and insert into the local database. I am providing some information below to give you pointers for the same.
a) Have to install the required provider/driver on the SQL Server machine.
Sybase ASA can be connected in following ways
OLE DB Providers
You need an OLE DB provider for each type of data source you wish to access. Each provider is a dynamic-link library. There are two OLE DB providers you can use to access Sybase IQ:
Sybase ASA OLE DB provider The Adaptive Server Anywhere OLE DB provider provides access to Sybase IQ as an OLE DB data source without the need for ODBC components. The short name for this provider is ASAProv.
When the ASAProv provider is installed, it registers itself. This registration process includes making registry entries in the COM section of the registry, so that ADO can locate the DLL when the ASAProv provider is called. If you change the
location of your DLL, you must reregister it.
If you use the Adaptive Server Anywhere OLE DB provider, ODBC is not required in your deployment.
Microsoft OLE DB provider for ODBC Microsoft provides an OLE DB provider with a short name of MSDASQL.
The MSDASQL provider makes ODBC data sources appear as OLE DB data sources. It requires the Sybase IQ ODBC driver.
b) Create a Linked Server and then query the same.
This link species the steps and some common errors while setting the Linked Server
Steps : sql-articles.com/.../creating-linked-server-to-sybase-from-sql-server (These are for ASE but are the same for ASA except that you have to choose a different provider/driver)
Issues : social.msdn.microsoft.com/.../fe29f12d-67b0-40a8-a41b-1767853a0185
I installed the ssma to convert mySQL to SQL Express, but, it doesn´t work. The button "convert" is not able and a message "SQL SERVER AGENT" is not ruuning. IT's obvisious thais is not running because sql express (2005) doens´t have it.
What can I do? email@example.com
MS Access to SQL Server
Why not support the extended property "Field Description" (of a table) and also automatically convert it ? Access and SQL Server support it both.
Any plans to support the conversion of the multi-level Access Attach-fields ?
best regards Klaus
The license key page is now 404. I need a license file. What is the correct URL?
Scott is right, license registration page is still a 404 error page... Dead in the water until I can get a license. Just sent an email to firstname.lastname@example.org though.
The very last step of Part 2 where you update the object table and cross apply with the value from cat.xml values in the tblRawData to get the conversion status throws the following errors:
Msg 8152, Level 16, State 14, Line 1
String or binary data would be truncated.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 23
Violation of PRIMARY KEY constraint 'PK__tblSSMAR__E3B3531E2FFBD6D4'. Cannot insert duplicate key in object 'dbo.tblSSMAReport_MessageDetails'. The duplicate key value is (EnginneringConstructionProject, report, 008a49a7-91c2-4c40-a402-55768e0f3d5e, A2SS0030).
Any suggestions / solutions?
So I was able to resolve the string or binary data would be truncated error by modifying tblSSMAReport_Object 'Name' from Varchar(32) to Varchar(40). Now we're left with the error:
Msg 2627, Level 14, State 1, Line 1
Han, do you have any suggestions?
Where can I obtain the license file? The link to the license file from the setup program brings me to a 404 error page.
On the Connect to Sql Server Window, the list of Server names is blank. Why can't SSMA find any Sql Server instances on my machine?
Trying to register license produced a 500 - Internal Server Error. Tried both Typical and Complete installation options. Cannot register license.
to get a license, one should login with a live id.