Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Migration from MS-SQL Server (on windows) to Sybase (on unix)

Status
Not open for further replies.
Coderifous

Coderifous

Programmer
Dec 13, 2001
782
US
My contract has inherited a legacy MS-SQL Server DB, and our mission will be to port it to Unix - the chosen target DB is Sybase. Not sure exactly who chose Sybase, but whatever. The good news, as I understand it, is that MS-SQL Server and Sybase have a shared heritage - making many features of the two common. The bad news is: I've never used either. I'm an open source guy living in a closed source world. My questions:

What tools/scripts/methods would any of you recommend for migrating the schema, migrating the data, and migrating the stored procedures/triggers?

Anybody have any experience with this? Highly compatible? Any gotchas? Any perl scripts? ;)

--jim
 
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question
Copy file from Sybase db to a network share that powerbuilder user does not have access to
Replies
0
Views
566
CharlesSwaim
C
RubensLott
  • Locked
  • Question
Retrieving windows version
Replies
1
Views
411
mbalent
mbalent
CFauvel2
  • Locked
  • Question
I am trying to hide an Adobe Ole Control error from the user using a nested Try/Catch.
Replies
1
Views
458
CFauvel2
CFauvel2
RubensLott
  • Locked
  • Question
Open a PDF file stored on a table
Replies
1
Views
535
RubensLott
RubensLott
JOELDD
  • Locked
  • Question
HOW TO SHOW FIRST COLUMN ON EACH PAGE OF AN INFOMAKER REPORT
Replies
0
Views
379
JOELDD
JOELDD

Part and Inventory Search

Sponsor

Back
Top