Forums » General Discussion

Thread: Synchronization Wizard: checkbox to enable/disable "schema" in output file


Permlink Replies: 0 - Pages: 1
Daniela.Waranie

Posts: 2
Registered: 12/16/10
Synchronization Wizard: checkbox to enable/disable "schema" in output file
Posted: Dec 16, 2010 8:14 AM
  Click to reply to this thread Reply

At the moment the output file is "restricted" to be imported to a specific database (schema). There should be an option to make the SQL file more "generic".

E.g.:
a) The following line should be removed when "schema" is disabled:
USE `database_schema_name_added_by_toad`;
b) All SQL statements should peel the schema:
INSERT INTO `myDB`.`mytable`
to:
INSERT INTO `mytable`

If i missed something and this feature is already existing: sorry - i am new to Toad.



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