What are the challenges you face when working across database platforms? Take the survey

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.


Sign In or Register to comment.