Hint:It is always wise to generate a DDLscript when using and ODBC connection
to generate a schema directly to a database server. Select the checkbox on the first
page of the generate wizard (see Figure 11–18).
If the database generation fails, you will see a server error message in the Output
window. After the first error, no other commands will be executed on the server.
Right click in the Output window and select Copy All Messagesfrom the context menu.
Paste the messages into a text editor. Compare the error messages to the generated
DDLscript to determine the cause of the database generation failure. If you ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.