What is the difference between exporting to MS SQL Server and MS SQL Server (enhanced)?

Article:TECH114020  |  Created: 2008-01-23  |  Updated: 2013-01-21  |  Article URL http://www.symantec.com/docs/TECH114020
Article Type
Technical Solution

Product(s)

Issue



What is the difference between exporting to MS SQL Server and MS SQL Server (enhanced)?

 


Solution



MS SQL Server - Exports the dataset or session log in a structured query language file that can be read by SQL database programs. Columns in the export are named with the field name and a sequential number.

MS SQL Server (enhanced) - Like the MS SQL Server format, this exports the dataset or session log in a structured query language file that can be read by SQL database programs. Only duplicate column names have a sequential number appended to the field name.

The only difference is how appended data is exported and matched in the column names from the query to the table. For example, if a query contains fields A, B, and C and is exported to MS SQL Server, it will export into columns A, B, and C in that order. The table must have the columns in the same order for the data to be exported correctly. But if a query has fields B, C, and A, and the columns in the table are A, B, and C, MS SQL Server (enhanced) will match the fields in the query to the columns in the table so the exported data goes into the correct place.



 



Legacy ID



2008012310324653


Article URL http://www.symantec.com/docs/TECH114020


Terms of use for this information are found in Legal Notices