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.

  • Email, SSL
  • 0 Bu dökümanı faydalı bulan kullanıcılar:
Bu cevap yeterince yardımcı oldu mu?

Related Articles

How to Install MRTG

Solution Steps for MRTG installation are documented as MRTG Installation Make sure MRTG is NOT...

Execute a SQL script (.sql file) on MsSql Server database

To execute a .sql file, you need to open the “Query Analyzer” Start -> Programs ->...

Change the root password for a *nix server

In order to change the root password login to the server as root and type the following, then...

How does memory overcommit affect PostgreSQL?

In Linux 2.4 and later, the default virtual memory behavior is not optimal for PostgreSQL....