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 Kunder som kunne bruge dette svar
Hjalp dette svar dig?

Related Articles

Reset the SQL Server ‘sa’ user password?

Open Enterprise Manager and expand the registered SQL server. Expand Security. Click on...

How does memory overcommit affect PostgreSQL?

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

Change the DNS servers for the network interfaces on my Windows server

In Network Connections, right-click the local area connection, and then click Properties. In...

Fix Lame Nameserver Error

A lame server, is one that is specifed at the registrar to be authoritative for a domain, but...

Manage Query Cache

You can check whether the query cache is present in your MySQL server using the following...