Hướng dẫn export database sql server 2008

     

Feedback will be sent khổng lồ jdomain.vn: By pressing the submit button, your feedback will be used lớn improve jdomain.vn products and services. Privacy policy.

Bạn đang xem: Hướng dẫn export database sql server 2008


In this article

Applies to:

*
SQL hệ thống (all supported versions)
*
SSIS Integration Runtime in Azure Data Factory

Start the SQL hệ thống Import và Export Wizard in one of the ways that is described in this topic to lớn import data from & export data lớn any supported data source.


Important

This topic describes only how to start the wizard. If you"re looking for something else, see Related tasks & content.


You can start the wizard:

Prerequisite - Is the wizard installed on your computer?

If you want to run the wizard, but you don"t have jdomain.vn SQL vps installed on your computer, you can install the SQL server Import & Export Wizard by installing SQL server Data Tools (SSDT). For more info, see download SQL server Data Tools (SSDT).


Note

To use the 64-bit version of the SQL hệ thống Import & Export Wizard, you have to lớn install SQL Server. SQL vps Data Tools (SSDT) & SQL server Management Studio (SSMS) are 32-bit applications and only install 32-bit files, including the 32-bit version of the wizard.


Start menu

Start the SQL server Import & Export Wizard from the Start menu

On the Start menu, find and expand jdomain.vn SQL server 20xx.

Click one of the following options.

SQL vps 20xx Import và Export Data (64-bit)SQL vps 20xx Import và Export Data (32-bit)

Run the 64-bit version of the wizard unless you know that your data source requires a 32-bit data provider.

*

Command prompt

Start the SQL server Import và Export Wizard from the command prompt

In a Command Prompt window, run DTSWizard.exe from one of the following locations.

C:Program Filesjdomain.vn SQL Server140DTSBinn for the 64-bit version.

140 = SQL server 2017. This value depends on the version of SQL vps you have.

C:Program Files (x86)jdomain.vn SQL Server140DTSBinn for the 32-bit version.

140 = SQL server 2017. This value depends on the version of SQL server you have.

Run the 64-bit version of the wizard unless you know that your data source requires a 32-bit data provider.

Xem thêm: Hướng Dẫn Sử Dụng Phần Mềm Chống Hack Aoe Dành Cho Game Thủ, Phần Mềm Chống Hack Đế Chế Aoe 2020

*

SQL server Management Studio (SSMS)

Start the SQL server Import và Export Wizard from SQL hệ thống Management Studio (SSMS)

In SQL server Management Studio, connect khổng lồ an instance of the SQL hệ thống Database Engine.

Expand Databases.

Right-click a database.

Point khổng lồ Tasks.

Click one of the following options.

Import Data

Export Data

*

If you don"t have SQL hệ thống installed, or you have SQL hệ thống but don"t have SQL hệ thống Management Studio installed, see tải về SQL hệ thống Management Studio (SSMS).

Visual Studio

Start the SQL server Import & Export Wizard from Visual Studio with SQL hệ thống Data Tools (SSDT)

In Visual Studio with SQL hệ thống Data Tools (SSDT), with an Integration Services project open, vày one of the following things.

On the Project menu, click SSIS Import & Export Wizard.

*

- or -

In Solution Explorer, right-click the SSIS Packages folder, và then click SSIS Import and Export Wizard.

*

If you don"t have Visual Studio installed, or you have Visual Studio but don"t have SQL vps Data Tools installed, see download SQL vps Data Tools (SSDT).

Get the wizard

If you want to lớn run the wizard, but you don"t have jdomain.vn SQL server installed on your computer, you can install the SQL server Import và Export Wizard by installing SQL hệ thống Data Tools (SSDT). For more info, see download SQL server Data Tools (SSDT).

Get help while the wizard is running


Tip

Tap the F1 key from any page or dialog box of the wizard to see documentation for the current page.


What"s next?

When you start the wizard, the first page is Welcome to SQL vps Import và Export Wizard. You don"t have lớn take any kích hoạt on this page. For more info, see Welcome khổng lồ SQL server Import and Export Wizard.


Chuyên mục: Domain Hosting