[EMAIL PROTECTED] wrote:
> If you want to move the entire db with data, you may want to look at this:
> 
> http://www.spaceprogram.com/products_prompand.html
> 
> Travis

the procedure to move the db with torque:

project-jdbc -> create a torque schema
project-datadtd -> creates a dtd for your data xml
project-datadump -> creates xml containing all your data
project-sql -> generates sql for your target db
project-datasql -> generates sql to insert the data
project-create-db -> creates the target db
project-insert-sql -> creates the tables and inserts the data

haven't tried it with a complex db .. so give it a try and please report to the list
if there are any problems we'll figure it out and save you 1000 bucks ;-)

martin

> 
> ---- Original Message ----
> From: Berin Loritsch <[EMAIL PROTECTED]>
> Sent: 2002-05-15
> To: 'Turbine Torque Users List' <[EMAIL PROTECTED]>
> Subject: Reverse engineering utilities?
> 
> Are there any utilities to reverse engineer a database?  It would really
> be cool to use the JDBC metadata facilities to create the Torque
> descriptor
> from an existing database.
> 
> I have an existing legacy database in Informix that has around 100
> tables,
> I would rather not do the busy work of manually creating the Torque
> descriptor.  Esp. since some of those tables have more than 20 columns!
> 
> I want to convert the database to a MySQL database--and the Torque
> project is the perfect way to do that.  Esp. since it takes care of a
> lot
> of busy work for me.
> 
> 
> "They that give up essential liberty to obtain a little temporary safety
>  deserve neither liberty nor safety."
>                 - Benjamin Franklin
> 
> 
> --
> To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
> 
> 
> 
> --
> To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
> 




--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to