I am trying to convert MS SQL server database to Oracle and all of the table and columns are lowercase and being converted with double quotes around them. Is there a way in FME to prevent this?
Solved
Microsoft to Oracle, table and columns created with "double quotes"
Best answer by erik_jan
The Oracle writers have the option to use uppercase column names.
Checking this option will create table and column names in uppercase (default for Oracle, but not for SQL Server).
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+26- Contributor
- Best Answer
The Oracle writers have the option to use uppercase column names.
Checking this option will create table and column names in uppercase (default for Oracle, but not for SQL Server).