Database Conversion through Powerbuilder?

[golyg]

Hi all!
First, I hope this is the correct forum for this question.

I have been honored with the privilege to create a database conversion program for a SQL Anywhere 5.0 db but there is a slight problem: I have no idea where to start.
Is it just a bunch of queries? or what?
Should I create an .exe just for this?

Any suggestions would be greatly appreciated.
TIA,
g

 

[BetterLateThanNever]

It depends entirely on how complicated the conversion is. Are you converting between one DBMS and another or are the two databases both under the same DBMS? If you need to do a great deal of manipulation of the data then PB could be helpful to you. You could use the datawindows to great effect. PB will allow you to connect to as many databases as you need. If you are only copying data between tables then you could probably do most of this via SQL scripts. Is it a one-off conversion? How strong is your SQL knowledge? You may find that a combination of pure SQL and PB will be the best solution.

Cheers.

 

[golyg]

thanks for the reply,
actually the conversion is pretty small, updating 1 table; adding a column and inserting a new index, but they would like a small app.
The last conversion was large, and they had an app for that and really liked it.
I am going through the motions of creating a new project and somewhere in a datawindow, I'll throw in a small script.

thanks,