AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Toad data modeler not generating script3/29/2024 How is this possible? I could probably exclude these checks from the compare but I don't want to keep excluding things in the compare list because I may miss things that I validly need the wizard to pick up. Specify exact version and type (freeware/trial/full) when submitting test reports. To implement the alternate key, but the wizard thinks that the AK still does not exist in the database and then for some reason it lists the opposite in red below? They're exactly the same its like the wizard is confirming that its wrong? I know TOAD created the scriptĪLTER TABLE. Toad Data Modeler enables users to reverse engineer database structures, update models, design and generate SQL, compare models and generate alter scripts, create HTML or RTF reports, in addition to versioning of database designs and creation of to-do lists. The second discrepency is the most baffling. Firstly the wizard claims the Alternate key is not unique in the database, not sure how this can be, I know for sure TOAD creating a unique constraint on the alternate key I specified so why is there a discrepancy here? It of course creates an alter script to try and fix the problem but it just drops and re-creates the unique constraint and the above display repeats itself again when I use the synchronize wizard? I have tried to implement an Alternate key with TOAD in a dimension table by specifying a unique attribute in the entity attribute settings for this Company dimension.
0 Comments
Read More
Leave a Reply. |