RE: Copying database IDS 7.3 to mysql
Fred (au boulot) said
> To continue my development when i am out of office, i am in
> need to export
> all my database stored with IDS 7.3 to mysql on my laptop. My biggest
> problem is that the creator of the database named a field
> "change" wich is
> a reserved word in mysql. I tried to use a tools called
> Sqlways to do the
> transfert but I am not able to bypass the tables with the
> field "change"
>
> Does someone know a procedure to do this kind of work
>
What Operating System are you using?
With Unix or Linux you can write a small script to change the field name in the
SQL, assuming you are doing a dbschema or dbexport.
Any way you can just use an editor to change the SQL.
What method are you using to export from Informix ?
Colin Bull
c.bull@videonetworks.com
sending to informix-list
Hi,
"Colin Bull" <c.bull@videonetworks.com> a 'crit dans le message de
news:c4282u$i58$1@terabinaries.xmission.com...
>
>
>
> Fred (au boulot) said
>
> > To continue my development when i am out of office, i am in
> > need to export
> > all my database stored with IDS 7.3 to mysql on my laptop. My biggest
> > problem is that the creator of the database named a field
> > "change" wich is
> > a reserved word in mysql. I tried to use a tools called
> > Sqlways to do the
> > transfert but I am not able to bypass the tables with the
> > field "change"
> >
> > Does someone know a procedure to do this kind of work
> >
>
> What Operating System are you using?
> With Unix or Linux you can write a small script to change the field name
in the
> SQL, assuming you are doing a dbschema or dbexport.
>
> Any way you can just use an editor to change the SQL.
>
> What method are you using to export from Informix ?
>
> Colin Bull
> c.bull@videonetworks.com
>
> sending to informix-list
IDS is installed Windows 2000 server and the laptop use win Xp pro.
I can export the Database using dbexport and as you said changing the name
of the field name is not a big problem. As i am not familiar enough with
mysql to import the database in MySql ... i will go and ask in a mysql
newsgroup :-)
Many thanks for your help.
Fred