Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the procedure to reverse engineer a database or SQL DDL script into Visible Advantage?

April 26, 2017advantage database DDL engineer procedure reverse Script sql visible

0

10 Posted

What is the procedure to reverse engineer a database or SQL DDL script into Visible Advantage?

1 Answer

0

10 Posted

A. Below are the steps to import a SQL Server database into Visible Advantage by connecting directly to the database using ODBC and importing a SQL DDL script. NOTE: The client PC has to have the SQL Server ODBC drivers installed before this procedure can be performed. The example below uses MS SQLServer, but the same procedure would be used for any ODBC compliant database. Method 1: Importing Using ODBC: Create an ODBC DSN in the ODBC Administrator using the MS SQLServer ODBC driver. Open the Visible Advantage Interfaces program, and select Reverse Engineering | 32- bit ODBC. At the “Save to VSC file” dialog box, enter the name and location of the export file, “SQL_impt.ad” for example, and click OK. At the Select Data Source dialog box, select the SQLServer ODBC DSN, and click OK. Confirm the SQLServer user name and password, and click OK. Once the Interfaces program connects to the database, a list of the tables and views in the database are displayed. Select the tables to be import