The problem:

Our server database contains 1TB of data. It runs on a Sybase ASE 15.7 server and shall be migrated to SQL Server 2014. The servers will be located in the same data center during migration; an acceptable downtime is 6 hours.

We have considered using Sybase Replication Server, as we understand it, this product supports heterogeneous database replication from ASE to SQL. However; we do not have experience with this. Snapshot and transactional replication might be a possible solution.

We have some experience with SQL Server Migration Assistant and have successfully migrated the database objects and data in a test environment. However based on 8% test data, we have estimated that a complete migration of production database will take about 7 days. We can only have 6 hours downtime, and are not sure if this product can be used for data migration in our case. For database objects, this product has worked fine.

Do you have some recommendations to solve this problem?

  • There will always be a requirement to minimize downtime, so that doesn't really tell us anything. How long can you be down? Is your SQL Server up and running? Do you have the ability to migrate and transactionally update? – Steve Mangiameli Jan 19 '16 at 22:43
  • Thanks for your question, I have update the problem description with more details. – Oyvind Jan 20 '16 at 8:01
  • Wats your Sql server hardware? Depending on that you can increase memory or multi threading maxdop configuration – Hiten004 Jan 20 '16 at 11:35
  • The servers are hosted in ESX using a VPLEX SAN and ExtremIO SSDs. I believe we can optimize more, but I am not convinced we can do this in 6 hours with SSMA. As I understand it, for a consistent data migration, the database must be offline when we are using SSMA. – Oyvind Jan 20 '16 at 12:27
  • 1
    Replication Server transactional replication would likely be a good fit for your needs. Once replication is initiated, the servers could be kept nearly identical until your cutover date. – Michael Gardner Jan 25 '16 at 16:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.