Wednesday, December 12, 2012 10:09 AM
I am looking for a sample in c# to compare database schema using Microsoft.Data.Schema.Tools.Compare
- Moved by Sethu SrinivasanMicrosoft Employee Wednesday, December 12, 2012 5:35 PM SSDT - Schema compare (From:SQL Server SMO/DMO)
Thursday, December 13, 2012 11:29 PMModerator
Assuming the question relates to SQL Server Data Tools, there is no public API to accomplish this.
What are you trying to accomplish?
-GertD @ www.sqlproj.com
Friday, December 14, 2012 4:32 PM
Sorry if I'm jumping the gun, but as Gert says, there is currently no public API for this. I have an open Connect item for the slightly different issue of an API for the Visual Studio projects; you might like to comment and/or vote there if you would like to see this.
Friday, December 14, 2012 7:34 PM
Thanks! I voted for it
Wednesday, December 19, 2012 11:34 AM
Thanks, that's great. Make sure you leave a comment on there, though, with what APIs you want exposed. Try to be specific about what exactly you want to accomplish; for example "I want to be able to determine whether a remote server has the same schema as a dacpac". This kind of comment will let the SSDT team know what parts are important to developers.