Dacpacs

Rjb23

Hi,

I have a situation where I would like to compare a dacpac to an existing database using the sql compare sdk. Has anyone done this before? Any ideas if this can be done?

Allen LeVan

Hello,

Thanks for your question on the SQL Compare SDK. For DACPAC's while there are no built in methods to access and compare them, if in your application you unpack them and write them to a format SQL Compare can look at then you should be fine. I would think writing them out to a scripts folder would be the easiest but I have not done this process myself.

Rjb23

Allen,

Thank you for the reply. I have actually figured out how to do the compare with a scripts folder, I just now need to figure out how to unpack the dacpac with a command line, or in c# code.