Export Data from Database to Path

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

Export Data from Database to Path

Postby abjacs » Tue Jan 12, 2010 6:48 am

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?
abjacs
 
Posts: 6
Joined: Fri Dec 19, 2008 8:34 pm

Postby Chris Auckland » Wed Jan 13, 2010 6:49 pm

That's correct, synchronizing the schema and the data will be a two step process.

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.
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