How to Export a SQL Server Database Table When Troubleshooting Enterprise Vault (EV)
Article ID: 100029386
Updated On:
Resolution
As a part of troubleshooting EV, database tables may need to be exported to an Excel file. Please follow the instructions below to perform an export on a SQL server:
(1) Exporting on SQL Server 2005
1. Open the Microsoft SQL Server Management Studio.
2. Expand the console tree to display the name of the database to be exported.
3. Right-click on the database name, and select Tasks - Export Data ...
4. From the Data Source drop-down list, select Microsoft OLE DB Provider for SQL Server ; ensure that the correct SQL server name and database are selected, and the Authentication is set to Windows Authentication. Click Next.
5. From the Destination drop-down list, select Microsoft Excel. Specify the file path and ensure that Microsoft Excel 95 - 2007 is selected as the Excel version. Click Next.
6. On the next screen, ensure that "Copy data from one or more tables or views". Click Next.
7. From the list of tables and views, tick boxes to select tables to be exported. Click Next.
8. Ensure that the "Execute immediately" is selected, and click Finish.
9. After the export is complete, cancel the export wizard.
(1) Exporting on SQL Server 2005
1. Open the Microsoft SQL Server Management Studio.
2. Expand the console tree to display the name of the database to be exported.
3. Right-click on the database name, and select Tasks - Export Data ...
4. From the Data Source drop-down list, select Microsoft OLE DB Provider for SQL Server ; ensure that the correct SQL server name and database are selected, and the Authentication is set to Windows Authentication. Click Next.
5. From the Destination drop-down list, select Microsoft Excel. Specify the file path and ensure that Microsoft Excel 95 - 2007 is selected as the Excel version. Click Next.
6. On the next screen, ensure that "Copy data from one or more tables or views". Click Next.
7. From the list of tables and views, tick boxes to select tables to be exported. Click Next.
8. Ensure that the "Execute immediately" is selected, and click Finish.
9. After the export is complete, cancel the export wizard.
(2) Exporting on SQL Server 2008
1. Open the Microsoft SQL Server Management Studio.
2. Expand the console tree to display the name of the database to be exported.
3. Right-click on the database name, and select Tasks - Export Data ...
4. From the Data Source drop-down list, select SQL Server native Client 10.0 ; ensure that the correct SQL server name and database are selected, and the Authentication is set to Windows Authentication. ClickNext.
5. From the Destination drop-down list, select Microsoft Excel. Specify the file path and ensure that Microsoft Excel 2007 is selected as the Excel version. Click Next.
6. On the next screen, ensure that "Copy data from one or more tables or views". Click Next.
7. From the list of tables and views, tick boxes to select tables to be exported. Click Next.
8. Ensure that the "Run immediately" is selected, and click Finish.
9. After the export is complete, cancel the export wizard.
(3) Exporting on SQL Server 2012
1. Open the Microsoft SQL Server Management Studio.
2. Expand the console tree to display the name of the database to be exported.
3. Right-click on the database name, and select Tasks - Export Data ...
4. From the Data Source drop-down list, select SQL Server native Client 11.0 ; ensure that the correct SQL server name and database are selected, and the Authentication is set to Windows Authentication. ClickNext.
5. From the Destination drop-down list, select Microsoft Excel. Specify the file path and ensure that Microsoft Excel 2007 is selected as the Excel version. Click Next.
6. On the next screen, ensure that "Copy data from one or more tables or views". Click Next.
7. From the list of tables and views, tick boxes to select tables to be exported. Click Next.
8. Ensure that the "Run immediately" is selected, and click Finish.
9. After the export is complete, cancel the export wizard.
3. Right-click on the database name, and select Tasks - Export Data ...
4. From the Data Source drop-down list, select SQL Server native Client 11.0 ; ensure that the correct SQL server name and database are selected, and the Authentication is set to Windows Authentication. ClickNext.
5. From the Destination drop-down list, select Microsoft Excel. Specify the file path and ensure that Microsoft Excel 2007 is selected as the Excel version. Click Next.
6. On the next screen, ensure that "Copy data from one or more tables or views". Click Next.
7. From the list of tables and views, tick boxes to select tables to be exported. Click Next.
8. Ensure that the "Run immediately" is selected, and click Finish.
9. After the export is complete, cancel the export wizard.
Issue/Introduction
How to Export a SQL Server Database Table When Troubleshooting Enterprise Vault (EV)
Was this article helpful?
Yes
No
Powered by
