Load project options using API library

[kkchan]

Hi,

Just to double confirm that, If I have set all the replication option and save it. Can I use SQL toolkit C# library to load the settings from project file so that I don't have to hardcode inside my application?

[richardjm]

If you are talking about SQL Data Compare version 6 then yes. You will have to call the function Project.ReplayUserActions() for your SchemaMappings.

HTH
_________________
Richard Mitchell
Project Manager
Red Gate Software Ltd

[jimboh]

Please provide more DETAIL information as to how this is used .
When I suck in a project file, the resulting comparison does not have any regard for the tables and and views and column filters that i have set in the project configuration - whether the project.RepayUserActions is used or not.

[richardjm]

No need to SHOUT.

Please see a related article...

http://www.red-gate.com/MessageBoard/viewtopic.php?t=6236&highlight=replayuseractions
_________________
Richard Mitchell
Project Manager
Red Gate Software Ltd

[jimboh]

Sorry for the unnecessary emphasis.

I have seen the reference and applied the function call you refer to in this manner:

using (ComparisonSession session = new ComparisonSession())
{
// Create the mappings between the two db
SchemaMappings mappings = new SchemaMappings();

project.ReplayUserActions(ref mappings);
// TODo 20080328 -- this is wierd !! http://www.red-gate.com/MessageBoard/viewtopic.php?t=6236&highlight=replayuseractions

mappings.Options = project2.Options;

mappings.CreateMappings(db1, db2);

session.CompareDatabases(db1, db2, mappings);

Console.WriteLine("Comparison run");

etc.

[richardjm]

OK I can see what's going on there. What you're after is creating the mappings *then* applying the user actions and you're ready to roll...

[jimboh]

I like your style .. I'm actually smoking arolly right now.
also you picked up on project vs project2

Unfortunately the following loop :
foreach (TableMapping mapping in mappings.TableMappings) ...
still wants to use every table in the database - rather than just the ones in the project configuration.

Thanks
Jimboh

[jimboh]

perhaps you need to see the following preliminary lines ( copied from the template)

//Should check if this is true
LiveDatabaseSource liveDb = project2.DataSource1 as LiveDatabaseSource;
db1.RegisterForDataCompare(liveDb.ToConnectionProperties(), Options.Default);

//Should check if this is true
liveDb = project2.DataSource2 as LiveDatabaseSource;
db2.RegisterForDataCompare(liveDb.ToConnectionProperties(), Options.Default);

is there some thing more that should be done first ?

[richardjm]

which would then continue (for project2)

[jimboh]

RichardJim

Please don't keep me in suspense. where and how do we use .Include and what object is it referring to ?

Jimboh

[richardjm]

If you're using the

[jimboh]

richardjim

I think we are there. The use of mapping.Include property in the manner as you suggest, provides the necessary filter.

The API documentation could certainly be a bit more forthcoming in how this property is applied.

Ultimately, in this current exercise, I am trying to do an Export - similar to SQLDataCompare export - except I only want the left side and no duplicate columns in the CSV/xml file. This is mainly to get Static data for version control -- the aspect that is missing from SQL Compare scripting.

It must be getting close to close of business time in Cambridge and I thank you for your care and attention.

Until next time,

Jimboh

[richardjm]

Happy to help.
_________________
Richard Mitchell
Project Manager
Red Gate Software Ltd