OT: Techy help - Sybase to SQL Server

Come and join in the banter: discuss here anything you want, whether bike related or not!
FoldingJoe
Posts: 1171
Joined: Tue Mar 15, 2011 18:31 pm

OT: Techy help - Sybase to SQL Server

Postby FoldingJoe » Tue Jan 22, 2013 14:13 pm

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

FoldingJoe
Posts: 1171
Joined: Tue Mar 15, 2011 18:31 pm

Re: OT: Techy help - Sybase to SQL Server

Postby FoldingJoe » Tue Jan 22, 2013 14:18 pm

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
Posts: 3409
Joined: Thu Jul 02, 2009 15:16 pm

Re: OT: Techy help - Sybase to SQL Server

Postby TGOTB » Tue Jan 22, 2013 14:35 pm

Is it just data/schema you need to migrate, or are there sprocs/triggers too?
Pannier, 120rpm.

FoldingJoe
Posts: 1171
Joined: Tue Mar 15, 2011 18:31 pm

Re: OT: Techy help - Sybase to SQL Server

Postby FoldingJoe » Tue Jan 22, 2013 14:44 pm

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

User avatar
CiB
Posts: 5780
Joined: Fri Sep 05, 2008 08:24 am

Re: OT: Techy help - Sybase to SQL Server

Postby CiB » Tue Jan 22, 2013 16:43 pm

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>

User avatar
itboffin
Posts: 16617
Joined: Thu Jun 05, 2008 23:54 pm
Contact:

Re: OT: Techy help - Sybase to SQL Server

Postby itboffin » Tue Jan 22, 2013 17:47 pm

Have you tried turning it off and then on again?
Rule #5 // Harden The fark 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.


Return to “Commuting Chat”

Who is online

Users browsing this forum: Fingerbobs, Mainsy and 4 guests