Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSMA 5.3 - Migrate Sybase ASE 15 to SQL Server 2012 - How to continuous sync-up the data? Expand / Collapse
Author
Message
Posted Wednesday, August 6, 2014 9:36 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 11:53 AM
Points: 18, Visits: 418
I want to migrate sybase ASE 15 to sql server 2012. On test servers, I successfully used SSMA 5.3 to sync-up schema and then do data migration. It took me 10 hrs to complete. Our prod Sybase is an 24/7 OLTP with over 30 dbs and each db has couple hundreds tables. So I can't afford to have them down for 10 hrs.

Is there a way to continuous sync-up the data between Sybase and SQL Server?

Sybase Replication Server is not an option for me. I poked around with SSMA a bit and it seemed to only do the schema sync-up, not data sync-up.

Any opinion would be greatly appreciated.

Thanh Nguyen
Post #1600296
Posted Thursday, August 7, 2014 11:10 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, October 17, 2014 10:29 AM
Points: 3,214, Visits: 2,343
Have you considered a phased migration approach ? By this I me migrating databases in 'discreet' groups. Granted you'll still probably have the same amount of down time overall, but your actual outages will be briefer.



Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #1600777
Posted Thursday, August 7, 2014 12:09 PM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 11:53 AM
Points: 18, Visits: 418
Thanks for your comments, Rudy.
'Phase' migration is not an option for me as those 30 dbs host one giant app. So very much all or nothing. I've talked to Microsoft SSMA engineer and learned that most likely they will include this feature 'continuous sync-up data between Sybase and SQL Server' in future version of SSMA since they've received quite a lot requests from big customers to add this capability. Anyways, in the meantime, per SSMA engineer, the only Microsoft solution is to use SSIS or t-sql MERGE to merge the data table by table. I guess...spending time to implement this custom solution and only use 'one-time' is not any DBA's favorite

Thanh
Post #1600808
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse