Only the SQL scripts of the database are exported, but the data in the table is still not exported. Next we will solve this problem for you. If you are interested, refer to the tutorial.
Only the SQL scripts of the database are exported, but the data in the table is still not exported. Next we will solve this problem for you. If you are interested, refer to the tutorial.
Many friends asked SQL server database "generate scripts" and exported only the SQL scripts of the database, while the data in the table is still not exported. It is very simple. Take a look at the Tutorial:
Note: I use SQLServer2008 here. Other versions should be similar.
1. Select the database to be exported-> task-> Generate script (or you can find the script generated in the task !)
2. In the "Generate and release scripts" window, click Next.
3. Select the database object for script writing and select the first one for all export. If you want to export some data, check the second one.
4. Click "advanced" after the screen appears (Focus)
5. "types of data to be written" corresponds to "Architecture and Data"
6. Confirmation, next step, next step, and success.