Schema Import Wizard

The Schema Importer provides you with the option of importing the schema of an existing database info CodeStencil.

You can access the Schema Importer with the hotkey - CTRL+SHIFT+I

OR

From the Tools menu:

The Schema Import Wizard (SIW) helps you import the database schema from various databases, including SQL Server, MySql, SQLite, etc.

  1. Database
  2. Server Location
  3. Refresh
  4. SQL Server(s)
  5. SQL Server Authentication
  6. Windows Authentication
  7. User/Password
  8. Use Trusted Server Certificate
  9. Refresh - This generates a list of databases
  10. Database(s) - Droplist that will display available databases on the server
  11. Connection String - A connection string will be generated and displayed here.
  12. Test/Connect to Database - This button will connect to the database and retrieve table/view names.
  13. Tables - The retrieved table names will be displayed here.
  14. Scaffold Logic - This text explains how the Table Name labels are retrieved, depending on what you set up in the options (See Test/Connection To Database).

 


Was this article helpful?