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.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

After restoring a SQL Server database, it show a status of “Loading”

Getting the database out of LOADING state When restoring multiple backups, each backup needs...

Backing up and restoring a MySQL database from the command line

. Shell into your box as root, then: mysqldump -a -u USERNAME -p DATABASE > FILENAME.mysql...

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...

Change the DNS servers for the network interfaces on Windows server

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

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...