February 17, 2015 at 11:27 am
Hello,
Not sure if this is the right forum.
I am working on solution on migrating Sybase database to SQL Server 2014 and have few questions and a quick response will be appreciated:
1. Does SSMA support ALL versions of Sybase database (ASA, ASE, etc.)? If not, then what all versions of sybase does it support?
2. Is there any other migration tool that covers all the versions of Sybase database?
3. If there is no tool available to migrate very old versions of Sybase, then what approach can be taken to migrate the Sybase database to SQL Server 2014?
February 18, 2015 at 3:52 pm
Hi..
Firstly, yes you probably are on the wrong forum, but I'll try anyway.
1: After a quick search I found this SSMA:
SSMA for Sybase v6.0 is designed to support migration from Sybase ASE version 11.9 and higher to all editions of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 and Azure SQL DB.
So only ASE 11.9 and upwards apparently.
2: After another quick search I wasn't able to come up with anything more open source.
3: If I were you, and you were going to need to re-do the migration from a Sybase database that was currently under development, I'd spend the time to create a BIML package for SSIS that would look at all the relevant tables in the Sybase server and generate SSIS packages for you. You'd need to watch out for conversion issues though. But I'd go with SSIS.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply