When you have run a comparison, you can export the comparison, or a subset of the results, to a collection of comma-separated value (CSV) files. For example, you may want to produce a detailed report or to keep a record of the comparison results.

1. On the Tools menu, click Export Comparison Results.
   The Export Comparison Results dialog box is displayed.
   
2. Type the path for the export files in the Export to box, or click Browse to choose the export folder. You can change the default path in the Application Options dialog box.
3. Select the check box in the Export column for the tables or views that you want to export.You can right-click the list of tables and views and click Include All to select all the check boxes or Exclude All to clear all the check boxes.
4. Under Rows to Include, select the check boxes for the rows that you want to export:
   
   • Identical includes rows that are the same in both databases.
   • Different includes rows that exist in both databases but are different.
   • Only in database name includes rows that exist only in that database.
5. Click Export.

For each selected table or view and for each of the row types that you selected under Rows to Include, SQL Data Compare creates a separate CSV file. SQL Data Compare also creates a Results Summary file.