Is there a way to include Temporary tables in compare?

coavlanche

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.

Tianjiao_Li

@coavlanche

Unfortunately temp table is not supported in SQL Compare.

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.