Copying database IDS 7.3 to mysql

Hi, 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 Many thanks in advance, Fred. ps : excuse my poor english :-)

Wouldn't be easy to put IDS on the laptop?? "Fred (au boulot)" wrote: > > Hi, > > 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 > > Many thanks in advance, > > Fred. > > ps : excuse my poor english :-) -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

Hi, "Paul Watson" <paul@oninit.com> a 'crit dans le message de news:4064BEFA.A94547B7@oninit.com... > Wouldn't be easy to put IDS on the laptop?? > > "Fred (au boulot)" wrote: > > > > Hi, > > > > 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 > > > > Many thanks in advance, > > > > Fred. > > > > ps : excuse my poor english :-) > > -- > Paul Watson # > Oninit Ltd # Growing old is mandatory > Tel: +44 1436 672201 # Growing up is optional > Fax: +44 1436 678693 # > Mob: +44 7818 003457 # > www.oninit.com # Of course, it would be easier to put IDS on the laptop, but i was not able to able to obtein from my boss to buy another licence (i work in a very small company) so i try to find a less expensive solution. Even with the little diffenrence between Informix SQL and Mysql SQL, i am able to continu my work on the laptop ... My major problem is the update of the laptop database with the server database ... i need to work with fresh data (less than 3 days old) and i cannot lose half a day every 3 days to synchronize the database with the workaround solution i use. Thanks in advance for the magical solution :-) NB: If you know of a "lite" version of IDS we could buy at low cost and install on the laptop that would be a great information. Fred

You could explain to the boss that the cost of all the messing around is a lot more than the cost of the license "Fred (au boulot)" wrote: > > Hi, > > "Paul Watson" <paul@oninit.com> a 'crit dans le message de > news:4064BEFA.A94547B7@oninit.com... > > Wouldn't be easy to put IDS on the laptop?? > > > > "Fred (au boulot)" wrote: > > > > > > Hi, > > > > > > 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 > > > > > > Many thanks in advance, > > > > > > Fred. > > > > > > ps : excuse my poor english :-) > > > > -- > > Paul Watson # > > Oninit Ltd # Growing old is mandatory > > Tel: +44 1436 672201 # Growing up is optional > > Fax: +44 1436 678693 # > > Mob: +44 7818 003457 # > > www.oninit.com # > > Of course, it would be easier to put IDS on the laptop, but i was not able > to able to obtein from my boss to buy another licence (i work in a very > small company) so i try to find a less expensive solution. > > Even with the little diffenrence between Informix SQL and Mysql SQL, i am > able to continu my work on the laptop ... My major problem is the update of > the laptop database with the server database ... i need to work with fresh > data (less than 3 days old) and i cannot lose half a day every 3 days to > synchronize the database with the workaround solution i use. > > Thanks in advance for the magical solution :-) > > NB: If you know of a "lite" version of IDS we could buy at low cost and > install on the laptop that would be a great information. > > Fred -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

"Paul Watson" <paul@oninit.com> wrote in message news:40652733.4E7F7AFF@oninit.com... > You could explain to the boss that the cost of all the messing around > is a lot more than the cost of the license Only if he charges your hourly rates, Paul :-)

Half a day every 3 days soon adds up to more than a new license. Neil Truby wrote: > > "Paul Watson" <paul@oninit.com> wrote in message > news:40652733.4E7F7AFF@oninit.com... > > You could explain to the boss that the cost of all the messing around > > is a lot more than the cost of the license > > Only if he charges your hourly rates, Paul :-) At least I have the advantage of not having to charge southern England rates:-)) -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #