Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How does the Migration Workbench handle reserved words?

April 26, 2017migration words workbench

0

Posted

How does the Migration Workbench handle reserved words?

1 Answer

0

Posted

If a column name is an Oracle Server reserved word, the Migration Workbench appends an underscore (_) when you create the object within an Oracle database. You can use ANSI names for objects by choosing Tools>Options, then selecting Create ANSI-compliant names from the General page. This means that all object names are surrounded by double quotes when you use the Migration Wizard to create them in the destination Oracle database. If you are using words that are not official T-SQL reserved words, but that have meaning in T-SQL syntax, you must enable the parser to recognize these words. Select the Allow ‘Reserved Words’ in table names option from the Parse Options tab within the Stored Procedures. You can enable this for a specific stored procedure or for all stored procedures. See Also: For more information on schema object names, see Schema Object Similarities in the Oracle Migration Workbench Reference Guide for Microsoft SQL Server and Sybase Adaptive Server Migrations.