Welcome to the Toad Data Modeling Community
Advanced Search - Help - Search Toad World
Welcome, Guest
Login Login / Register
Help
NEW? Get Plugged In

Forums » Join Discussions About... » Enhancement requests

Thread: Model conversion SQL handling

This question is answered. Helpful answers available: 2. Answered answers available: 1.


Permlink Replies: 3 - Pages: 1 - Last Post: Oct 29, 2009 7:18 AM by: modelingadmin
moakes

Posts: 254
Registered: 11/29/07
Model conversion SQL handling
Posted: Oct 29, 2009 6:46 AM
 
  Click to reply to this thread Reply

Hi,

When you convert a model to a different db, code is commented out.

This may be a valid thing to do if converting between different manufacturers databases, however when converting from (say) Oracle9i to Oracle10g I think it is unnecessary.
(In our model we would have to manually uncomment 100 000+ lines of code).

Can we have an option to turn this action off if we want to.

Regards
Malcolm



modelingadmin

Posts: 101
Registered: 2/14/07
Re: Model conversion SQL handling
Posted: Oct 29, 2009 6:53 AM   in response to: moakes
 
  Click to reply to this thread Reply

Hi Malcolm,

this option already exists. Use the Sync & Convert wizard (version 3.4.) and in fourth step, uncheck the "Comment Out Database Specific Items" check box. This will do what you want.

Regards,

Vaclav


moakes

Posts: 254
Registered: 11/29/07
Re: Model conversion SQL handling
Posted: Oct 29, 2009 7:01 AM   in response to: modelingadmin
 
  Click to reply to this thread Reply

Thanks Vaclav,

I had only tried Simple Model Conversion

Malcolm



modelingadmin

Posts: 101
Registered: 2/14/07
Re: Model conversion SQL handling
Posted: Oct 29, 2009 7:18 AM   in response to: moakes
 
  Click to reply to this thread Reply

I thought this was the case. :)

Regards,

Vaclav




Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums