Skip to main content
Solved

Microsoft to Oracle, table and columns created with "double quotes"

  • July 5, 2018
  • 1 reply
  • 10 views

Forum|alt.badge.img

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?

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).

View original
Did this help you find an answer to your question?

1 reply

erik_jan
Contributor
Forum|alt.badge.img+18
  • Contributor
  • Best Answer
  • July 5, 2018

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).


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings