Schema comparision - Default Filegroup

Question

Hi,

When I check my Project Database.sqlsettings, The default filegroup is mentioned as "Primary". Two things here.

1) When I check in a Create table script to TFS, The ON Primary is missing when I verify the solution.

2) When I perform a schema compare with any server, The schema difference is ignoring the filegroup which are created on Primary. I need a report to update the ON Primary filegroup for every script even though that is the default file group in the settings.

I checked out the option Ignore filegroups in the schema compare but these objects are skipped.

Appreciate your suggestions on this.

Answer 1

Hi Sowjanya,

We are looking into this query, and will get back to this thread. Please wait some time.

best regards,

---

Forrest Guo | MSDN Community Support | Feedback to manager

Answer 2

Hi Sowjanya,

The thread below explains the behavior and provides workarounds:

http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/fe3ba2e2-6a7e-4cb5-86e2-a181238ed9a7

Thanks,

Cathy Miller