![]() However, there are also many nasty little differences. ![]() it is true that ASE T-SQL and MSSQL T-SQL still have many similarities, so from that perspective things may work. In this project, possible to make minor changes to the application (and to freeTDS if needed), but not possible to touch all the code that is issuing CT calls - too many modules - too time consuming - practically not an option.Ĭoming from Sybase, and having written the book on ASE. Is there a better approach to address this problem ?.Is freeTDS needed ? Will bablefish talk to a client speaking TDS 5.X (or 4.X) on the babelfish port ?.Has anyone tried this approach for Sybsae->Postgresql.(My application) -> (make CT Calls) -> (freeTDS) -> TDS 7.X -> (Babelfish) -> (Postgresql). I believe best approach is to use openTDS, which provide the same API as the Sybase, and configure it to use TDS 7.X, which is supported by Babelfish. The second challenge is the Sybase CT API. Quick check has shown that all those constructs are supported by Microsoft T-SQL. Select foo, bar from table1 where key = x, y from table2 where key = and date = ? For example: (this is not real code, but it's similar to the pattern) declare int In few cases, the multi-statement queries use placeholders in the subsequent calls. ![]() The first challenge (in moving from Sybsae) is that the application make extensive use of multi-statement queries to return multi result sets, using dynamically generated Transact-SQL. I'm trying to evaluate if the BabelFish extension can help speed up migration. Application is built and run on Linux using SYBASE OCS-16. The application is using the Sybase CT library (nothing complex: simple SQL, few bulk uploads, etc.). I have a large Sybase ASE C/C++ app which I would like to migrate to Postgresql. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |