Hi,
I recently imported the schema of our prod database into Visual Studio. The schema solution builds, and I've used server variables in the sproc scripts. e.g., cross-db call in a sproc which was MyDB.dbo.sp_Some_Sproc is now [$(MyDB)].dbo.sp_Some_Sproc
However, as it's taken a while to get up and running properly with TFS etc., the prod schema is now slightly different from what I've got under source control. When I do a schema compare now, I get lots of differences because of these server variables in my stored schema.
Is it possible to do a schema compare, and ignore checking server variables? Thanks