Export the data from different tables in our shared SQL environment?

Using Enterprise Manager

Expand SQL Server group

Expand the server name

Expand Databases

Expand the database that you’ll be exporting data from

Click on Tables

Right-click the table you’d like to export, select All Tasks -> Export Data

The first dialog box asks where you’ll be copying the data from, just click Next

The next dialog box asks where you’ll be putting the data. You have a variety of options here, depending on what you’re trying to accomplishing. You can export the data to another SQL Server database, an Oracle database, an Excel spreadsheet, or even a plain text file. Follow the wizard to complete the task and export the data.

  • 1 utilizatori au considerat informația utilă
Răspunsul a fost util?

Articole similare

Manage Database Roles

Solution Database roles are conceptually completely separate from operating system users....

Manage Tablespaces

Tablespaces in PostgreSQL allow database administrators to define locations in the file system...

ColdFusion DSN parameters are not updated

SYMPTOMS New CF DSN records are created.  Even the set of parameters is tried to be updated...

Finding what packages are installed on a Linux system

For distributions that use RPM format packages, use the command: $ rpm -qa You may want to pipe...

What platforms does Linux support?

Linux runs on almost every general-purpose computer made in the last 10 years. It runs on systems...