Database Conversion Program??

[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?

Any suggestions would be greatly appreciated.
TIA,
g

 

[petersJazz]

Conversion of that?

 

[dickiebird]

"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"

Neither have we !
What will you be converting ?
You must gives some more clues - or, even better, all the facts. Dickie Bird
db@dickiebird.freeserve.co.uk

 

[golyg]

i have to update a SQL Anywhere 5.0 db.
here what:
-add a new column to an existing table (table 1)
-insert values in that new column
-drop the index for that table (table 1) and re-create an index for table a.

not too big of a conversion. i am creating a powerbuilder app to do this. the user wants a app for this.

when i do this, do i have to create a new db for this or can i use the existing one and insert the info??

thanks for you help,

 

[svanels]

I should start with reading about SQL commands

SQL in a nutshell from O'Reilly,

http://www.oreilly.com

could be helpful. Steven van Els
SAvanEls@cq-link.sr

 

[dickiebird]

You can do all this on the existing DB
The basics are :

alter table [database.[owner].]table_name
add column_name datatype

insert [into] [database.[owner.]]table_name
(column_name) values (expression...)

drop index table_name_idx
create index table_name_idx on table_name (column_name2, column_name2)

HTH ;-) Dickie Bird
db@dickiebird.freeserve.co.uk