How can we help you today? How can we help you today?

Is there a way to include Temporary tables in compare?

I need to compare/sync a view in one database to scripts, and then compare/sync that script to a TABLE in a database in another environment.  I was going to do a "Select * INTO ##TempTable FROM Table" first to create the temp table, and then run the compare to scripts, including that ##TempTable but in the GUI, there's no way to select or even see temporary tables and the project file object list is "compressed" so I can't just edit the XML project and add it.
coavlanche
0

Comments

2 comments

Sort by
  • Tianjiao_Li
    @coavlanche

    Unfortunately temp table is not supported in SQL Compare.
    Tianjiao_Li
    0
  • sam.blackburn
    My understanding is that most temporary tables are only visible to the connection that created them - it would be very difficult to compare and deploy them.
    sam.blackburn
    0

Add comment

Please sign in to leave a comment.