Skip to Content
0
Nov 06, 2012 at 09:52 AM

Change Database from Oracle to SQL Server

133 Views

I want to migrate a PowerBuilder 12.5 Win32 application from Oracle 10g to SQL Server 2008. I have copied tables and data. The problem is that data source of datawindows created with an Oracle Profile, cannot be opened in graphic mode with an SQL Server profile. If I convert them to syntax mode it works properly.

From what I figured out the problem lies at the fact that column and table names have been saved in lower case with Oracle profile, while SQL Server design mode wants them in upper case. Other than editing the data source, datawindows work properly (I can retrieve, edit, update data).

Can you suggest any solution to this problem? There are many datawindows and converting them one by one will be time consuming.