I just wanted to clarify a few points on using the Sql Compare SDK 8.0.
I want to export/extract the data from a physical database to a scripts folder that does not currently exist.
To do this via the API (and GUI) seems like a two-step process:
1. Extract the schema from the database to a scripts folder
2. Extract the data from the database to the previously created scripts folder
(Or, per RedGate lingo, synchronize the database to the scripts folder)
In any future scenario where I want to synchronize database schema/data to the scripts folder, I can just use SQL Compare and SQL Data Compare each again, and respectively.
Btw, for anyone else, using SQL Compare and SQL Data Compare with source control- http://downloads.red-gate.com/HelpPDF/ContinuousIntegrationForDatabasesUsingRedGateSQLTools.pdf
P.S. Where is the link to the SQL Compare v8.1 API documentation?