1. Luiz Ribeiro
  2. PowerBuilder
  3. Thursday, 3 November 2022 13:41 PM UTC

Hi all.

We have a desktop application that runs only on Oracle (currently using PowerBuilder 10 but we are already getting 2021).

I am looking for tips on better ways to make this application also run on SQLServer.

It is based on datawindows but also has DMLs in functions and events of PowerBuilder objects.

Currently we do not use functions/stored procedures in database.

Thanks in advance.

Accepted Answer
Andreas Mykonios Accepted Answer Pending Moderation
  1. Thursday, 3 November 2022 14:05 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi.

Oracle is PL-SQL. SQL Server is Transact-SQL. Depending of what and how you are doing in oracle, that may be an easy task or lot of work.

In Powerbuilder, do you use sql commands in scripts? Is your sql commande following ansi standards? Are you using any functions that are not standard functions? For example, oracle length function equivalent in sql server is len... T-SQL doesn't know to_char, to_date etc. And many other.

Finally, there is a big difference in oracle compared to sql server and other T-SQL databases. SQL server supports nested transactions. As you already support oracle and want to add support for sql server, this might not be an issue.

Finally this is a some points of my experience when I changed job and I had to use Oracle as database. In the past I was working with T-SQL (mostly sybase and SQL Anywhere). I can state that PL-SQL is more powerful. You may easy find things that in T-SQL will be harder to do...

Andreas.

Comment
There are no comments made yet.
mike S Accepted Answer Pending Moderation
  1. Thursday, 3 November 2022 13:51 PM UTC
  2. PowerBuilder
  3. # 1
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.