Shulou(Shulou.com)05/31 Report--

SQL Server how to export the data as a script, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

In object Explorer in SSMS2008 (SQL Server Management Studio 2008), right-click where you want to export data, and select the generate script option under tasks from the pop-up menu.

In the Select script options in the script wizard, there are the following important options to choose from:

Script data: whether to export table data in the database.

Include If Not Exists: this option deletes database objects with the same name that already exist in the database.

Write a script to create a database ": whether to generate a SQL script for Create Database\"

Script the server version: select the database version in which you want to execute the script.

Then the next step is to select the exported object, select the exported table, and when you are finished, you can see the table definition and table data exported by the system.

If the script is to be used by a remote database. There are generally two changes to be made, the first being CREATE DATABASE [DBNAME] (if the "script to create a database" option is selected) and USE [DATABASE]. The second place is to change the database architecture, generally using dbo locally, so press the Ctrl+ F key, select the replacement window, and replace dbo with [YOUR_SCHEMA] to complete the script transformation. Then you can open the remote database, create a new query, copy the script you just had, and execute it!

However, in practice, there may be a lot of compatibility problems if exporting from 08 to a lower version of sql, so when exporting a script to a lower version,

In the Select Database, you can uncheck the script all objects in the selected database check box

In "Select scripting options", note that the exported database version is selected in "scripting for server version" (2000, 2005, 2008)

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.