| SQL adaptation guide for SQL SERVER 2005, 2008, 2012, 2014, 2016 / Data dictionary | |
Informix® uses the following form to identify an SQL object:
[database[@dbservername]:][{owner|"owner"}.]identifier
With Microsoft™ SQL SERVER, an object name takes the following form:
[[database.]owner.]identifier
Object names are limited to 128 characters in SQL SERVER and cannot start with one of the following characters: @ (local variable) # (temp object).
To support double quotes as string delimiters in SQL SERVER, you can switch OFF the database option "Use quoted identifiers" in the database properties panel. But quoted table and column names are not supported when this option is OFF.
As a general rule, to write portable SQL, you should only use simple database object names without any database, server or owner qualifier and without quoted identifiers.
Check for single or double quoted table or column names in your source and remove them.