Getting Started #
If you used the Code Format Generator to create your formats and have the CSV export file ready, this article will guide you through how to apply those formats directly in your system.
In a typical implementation, the code format is always handled by the consultant, and clients do not apply their own code formats. This documentation exists for rare circumstances where direct application by the client may be necessary.
Apply using SQL Server Management Studio #
The generated CSV file also includes SQL UPDATE statements that can be executed in SQL Server Management Studio (SSMS).
To apply the updates:
- Open the CSV file in Excel to view the generated SQL statements.
- Copy and paste the UPDATE statements into SSMS.
- Execute the statements to apply the code formats.
Each statement is structured to update only the appropriate data type, ensuring accuracy and preventing format mismatches.
Apply using TAD #
This method requires that TAD is already installed in your environment—which may not be the case early in implementation. If you need to apply code formats using TAD, refer to the Implementation – Apply Code Format template. It provides step-by-step instructions to apply your formats seamlessly, ensuring accuracy and eliminating the risk of manual entry errors.
After applying the formats, go to the TAD Version form in Vista and click the Generate All Table Columns button to regenerate the columns with the new formats.