SQL Data Compare /w SDK output -> CSV like SQL Data Compare?

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

SQL Data Compare /w SDK output -> CSV like SQL Data Compare?

Postby binarymechanic » Wed May 05, 2010 6:42 pm

When data comparing using the SDK, is the ability to export to CSV exposed similar to what is available in SQL Data Compare/Tools/Export Comparison Results?

Thanks
Robert
binarymechanic
 
Posts: 6
Joined: Fri Mar 06, 2009 5:20 pm

+ one more question

Postby binarymechanic » Thu May 06, 2010 8:03 pm

Is it possible to use a SQL query as a source of a data compare?
There might be a query I want run and cannot choose from a view or table..
binarymechanic
 
Posts: 6
Joined: Fri Mar 06, 2009 5:20 pm

Postby Chris Auckland » Thu May 13, 2010 11:00 am

When data comparing using the SDK, is the ability to export to CSV exposed similar to what is available in SQL Data Compare/Tools/Export Comparison Results?


Unfortunatly that's buried deep in the UI, and isn't part of the API. Would you like me to log a feature request to make it avaliable?

It's possible to export the project to CSV using the SQL Data Compare command line interface, if that helps at all.

Is it possible to use a SQL query as a source of a data compare?
There might be a query I want run and cannot choose from a view or table..


You can configure a where clause to restrict the data being compared if that's what you're looking for. It is also possible to compare a sql script or a collection of scripts as a data source.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests