Export Data from Database to Path
abjacs
Posts: 11
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?
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?
Comments
You need to get the structure in place first, and then you can sync the data.
With regards to the SQL Compare 8.1 API, there isn't any updated documentation. However, you can download the sample applications that are built using the SQL compare 8.1 engine and SQL Data compare 8.0 engine from here.
I hope this helps.