Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Schema Compare database programatically in C#

Answered Schema Compare database programatically in C#

  • Wednesday, December 12, 2012 10:09 AM
     
     
    Sign In to Vote
    0

    Hello

    I am looking for a sample in c# to compare database schema using Microsoft.Data.Schema.Tools.Compare

    TIA

     

All Replies

  • Thursday, December 13, 2012 11:29 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    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
     
     Answered
    Sign In to Vote
    0

    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.

    Thanks,
    Tom

     
  • Friday, December 14, 2012 7:34 PM
     
     
    Sign In to Vote
    0

    Thanks! I voted for it

     
  • Wednesday, December 19, 2012 11:34 AM
     
     
    Sign In to Vote
    0

    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.

    Cheers,
    Tom