List of fields to change !!

promobil

Hi

I am using the SQL compare to Compare two databases, it works file, but I need to make som export to a test file, with a list like this:

TABLENAME;FIELD;ADD/DELETE/MODIFY
JOB;E-MAIL;ADD

Where can I read this Info ?
I have the following objects:
db1,db2 : Database;
Diffs : Differences;
NewWork : Work;

Thanks.

Regards
Thomas Olsen.

Brian Donahue

Hello Thomas,

Were you planning on writing your own SQL Toolkit project regardless? Because if all that you want to see is a text report showing the objects in the database and whether or not they are different, the SQLCompare.exe command-line version of SQL Compare will let you do that.

promobil

My program need to send the Field information to a Data replication Service, that will send data for the New fields in the Database.
I can NOT use the Commandline tool.
I can see that I have access to Alle the changed tables, but where can i see witch fields that have to be modyfied.

Regards Thomas Olsen.

Brian Donahue

Hi Thomas,

Then the most sensible option would be to loop through your collection of Diffs using a foreach loop, such as 'foreach (Difference d in Diffs)', and get the properties from each iteration of d and send that information where it needs to go. You can figure out if the object is different very easily by querying the Different property.