Implementing Clear/Voyager AI - CAD Integration
      Back to home
      1. Help Center
      2. New to Corti?
      3. Implementing Clear/Voyager AI - CAD Integration

      Exporting your database schema from SQL Server Management Studio (SSMS)

      A step-by-step guide for exporting a database schema from SQL Server Management Studio (SSMS)

      Here is a step-by-step guide for exporting a database schema from SQL Server Management Studio (SSMS):

      1. Open SQL Server Management Studio (SSMS) and connect to the database instance that contains the database schema you want to export.
      2. In the Object Explorer window, expand the Databases folder and find the database that contains the schema you want to export.
      3. Right-click on the database and select "Tasks" and then "Generate Scripts" from the context menu.
      4. In the "Generate Scripts" wizard, select the "Select specific database objects" option and choose the “Tables” checkbox. Click Next.
      5. On the "Set Scripting Options" page, click "Advanced", select the option “Types of data to script” and choose “Schema only”. Click OK.
      6. On the "Choose Output Options" page, specify the file name and location for the script to be saved. Click Next.
      7. On the "Summary" page, review the options you've selected and click "Finish" to generate the script.
      8. The script will be generated and saved to the location you specified in step 6. The script will not contain any customer data, only database tables and relationships.