Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Migration from Sybase SQL Anywhere to MS SQL Server.

  1. Advice
0
Votes
Undo
  1. Pushparaj V
    Pushparaj V
  2. PowerBuilder
  3. Thursday, 27 April 2023 18:22 PM UTC

Hi All,

We have PowerBuilder application with Sybase SQL Anywhere as the backend DB. Client wants to move to MS SQL Database, we are doing research on how we can do this migration, however we cannot find any straight forward approach. We have around 700+ Tables, 500+ Stored procedures, 100+ Functions and 100+ triggers.

Can you please help on sharing some help detail on how we can achieve this and any open source tool available for this.

Thanks in Advance. -Raj

  1. Migration
  2. SQL Anywhere
Using WINSCP SFTP within PowerBuilder 2017 applica...
Is a 32-bit application built with PowerBuilder 20...
Responses (2)
Andreas Mykonios
Andreas Mykonios Accepted Answer Pending Moderation
  1. Friday, 28 April 2023 06:38 AM UTC
  2. PowerBuilder
  3. # 1

Hi.

In addition to what Chris said, if you are using sql that is specific to sql anywhre there you should expect to have to do some changes - rewrite. Also, you stated you have a lot of stored procedures and functions. Depending on what language those are written, and if sql it's ansi sql, watcom sql e.t.c., you may have to do some rewrite.

Just curious, why clients do want to move to sql server?

Andreas.

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 27 April 2023 18:44 PM UTC
  2. PowerBuilder
  3. # 2

Hi Raj;

  There are lots of DBMS schema migration tools out there. In this case, Google is your friend.  ;-)

Regards... Chris 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.