OT: Techy help - Sybase to SQL Server

FoldingJoe
FoldingJoe Posts: 1,327
edited January 2013 in Commuting chat
Anybody migrated a Sybase db over to SQL server?

Any useful tools that one can use on the t'internet?

Cheers,
FJ
Little boy to Obama: "My Dad says that you read all our emails"
Obama to little boy: "He's not your real Dad"

Kona Honky Tonk for sale: http://www.bikeradar.com/forums/viewtopic.php?f=40090&t=13000807

Comments

  • FoldingJoe
    FoldingJoe Posts: 1,327
    From Sybase ASE 12.5.3 to SQL Server 2008 R2
    Little boy to Obama: "My Dad says that you read all our emails"
    Obama to little boy: "He's not your real Dad"

    Kona Honky Tonk for sale: http://www.bikeradar.com/forums/viewtopic.php?f=40090&t=13000807
  • tgotb
    tgotb Posts: 4,714
    Is it just data/schema you need to migrate, or are there sprocs/triggers too?
    Pannier, 120rpm.
  • FoldingJoe
    FoldingJoe Posts: 1,327
    The lot.

    Tables, Data, Sp's, Triggers.

    Looking at SSMA for Sybase, which looks like it might do the trick.
    Little boy to Obama: "My Dad says that you read all our emails"
    Obama to little boy: "He's not your real Dad"

    Kona Honky Tonk for sale: http://www.bikeradar.com/forums/viewtopic.php?f=40090&t=13000807
  • CiB
    CiB Posts: 6,098
    Does Sybase have an export object facility, that generates the necessary scripts? If so it might be easier to run those off and then knock up a noddy app to suck data out of one and blow it into the other. You'll have more control over it that way.
    </also an excuse to show your boss that you can do this sort of thing when called upon>
  • itboffin
    itboffin Posts: 20,052
    Have you tried turning it off and then on again?
    Rule #5 // Harden The Feck Up.
    Rule #9 // If you are out riding in bad weather, it means you are a badass. Period.
    Rule #12 // The correct number of bikes to own is n+1.
    Rule #42 // A bike race shall never be preceded with a swim and/or followed by a run.

Categories