How to Export Sql to Create a Database Schema in Mssql
I want to duplicate my database schema, but I do not want to copy the data contents. There are 3rd party tools which I can use to achieve th...
https://www.czetsuyatech.com/2021/07/mssql-export-create-schema-sql.html
I want to duplicate my database schema, but I do not want to copy the data contents. There are 3rd party tools which I can use to achieve the same result. But I prefer to use the Microsoft SQL Server Management Studio.
To do so:
1.) Open Microsoft SQL Server Management Studio
2.) Example we have a database named Anime:
a.) Right click on it -> Task -> Generate Scripts
3.) Introduction tab, click next
4.) Choose Objects tab, choose specific database objects, Select All, then unclick users. (I don't usually include users when backing up the schema)
5.) Set Scripting Options tab, change the "File name", to your desired location and file. Click Advanced.
a.) Options window, select SQL Server 2005 (since that's my current version)
b.) Type of Data to Script: Schema Only. Here you can choose Schema and Data if you like
c.) Click ok and then Next
6.) Review the Generate and Publish window, click Next then Finish
To do so:
1.) Open Microsoft SQL Server Management Studio
2.) Example we have a database named Anime:
a.) Right click on it -> Task -> Generate Scripts
3.) Introduction tab, click next
4.) Choose Objects tab, choose specific database objects, Select All, then unclick users. (I don't usually include users when backing up the schema)
5.) Set Scripting Options tab, change the "File name", to your desired location and file. Click Advanced.
a.) Options window, select SQL Server 2005 (since that's my current version)
b.) Type of Data to Script: Schema Only. Here you can choose Schema and Data if you like
c.) Click ok and then Next
6.) Review the Generate and Publish window, click Next then Finish
Post a Comment