Team Developer project Migration from Sybase to Sql Server

General discussion forum about all databases other than SqlBase.
mayank0cool008
India
Posts: 1
Joined: 07 Apr 2023, 19:57
Location: india

Team Developer project Migration from Sybase to Sql Server

Post by mayank0cool008 » 07 Apr 2023, 20:08

Has anyone done project migration on team developer from sybase to Sql server if yes, can you please share some link or pointers.

bjmbjm67
United States of America
Posts: 1
Joined: 12 Dec 2018, 21:12
Location: Bedminster, USA

Re: Team Developer project Migration from Sybase to Sql Server

Post by bjmbjm67 » 15 Sep 2023, 18:10

I am trying to migrate from sybase to sql manage instance on azure. has anyone been able to convert over using odbsal32.apl instead of sybsal32.apl, and use OdrPrepareProc, OdrExecuteProc, OdrPrepareNextResults, OdrGetNextResults and OdrGetReturnStatus. If yes any insight on how to use new Odr function. I was able to connect but when I call OdrExecuteProc on simple store procedure with no parameters but with on return row is returns failure.

User avatar
Steve Leighton
Site Admin
Site Admin
New Zealand
Posts: 338
Joined: 05 Mar 2017, 20:57
Location: Stroud, England <--> Tauranga, New Zealand

Re: Team Developer project Migration from Sybase to Sql Server

Post by Steve Leighton » 20 Sep 2023, 11:05

.
Sql Server instance on azure works fine with OLEdB ( make sure its MSOLEDBSQL not SQLOLEDB ) .
Its being treat with a higher priority by MS now over ODBC and is faster.
Greetings from New Zealand
Steve Leighton

Bankside Systems Ltd.
UK ♦ Australia ♦ New Zealand

www.banksidesystems.co.uk

Image

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 2 guests