Deploy only static table.

phonemyatt

Hi guys, I have multiple static tables that need to deploy from one db to another db. Is there easy way to data compare only static tables between this two db and deploy?
Thanks in advance

Sergio R

Not on a DB to DB comparison.
 However if this is Static Data that you setup with SQL Source Control, if you use Source Control as a Source it will only compare and deploy the tables with Static Data.

Sergio R

Hi,

Before running the actual comparison you can select the tables that you want to compare on the project settings (on the Table & Views tab).

phonemyatt

@Sergio R Thanks for the answer. To clarify, does that mean I have to select the static tables by myself and there is no filter just for static tables?