Red Gate forums :: View topic - SQL Data Compare /w SDK output -> CSV like SQL Data Compare?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK Previous Versions
SQL Comparison SDK Previous Versions forum

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

Search in SQL Comparison SDK Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
binarymechanic



Joined: 06 Mar 2009
Posts: 6

PostPosted: Wed May 05, 2010 6:42 pm    Post subject: SQL Data Compare /w SDK output -> CSV like SQL Data Compare? Reply with 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?

Thanks
Robert
Back to top
View user's profile Send private message
binarymechanic



Joined: 06 Mar 2009
Posts: 6

PostPosted: Thu May 06, 2010 8:03 pm    Post subject: + one more question Reply with 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..
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Thu May 13, 2010 11:00 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic 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