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?