| Author |
Message |
binarymechanic
Joined: 06 Mar 2009
Posts: 6
|
 Posted: Wed May 05, 2010 6:42 pm Post subject: SQL Data Compare /w SDK output -> CSV like SQL Data Compare? |
 |
|
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 |
|
| Back to top |
|
 |
binarymechanic
Joined: 06 Mar 2009
Posts: 6
|
| Posted: Thu May 06, 2010 8:03 pm Post subject: + one more question |
|
|
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.. |
|
| Back to top |
|
|
Chris Auckland
Joined: 24 Oct 2006
Posts: 710
Location: Red Gate Software Ltd.
|
| Posted: Thu May 13, 2010 11:00 am Post subject: |
|
|
| Quote: |
| 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.
| Quote: |
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 |
|
| Back to top |
|
|
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
