index > Visual Studio Source Control and SourceSafe > SQL Server project compare to DB

SQL Server project compare to DB

Is there a way to compare the SQL Server Project's stored procedure scripts to the actual stored procedures in the SQL Server database?

Chomsky Tuesday, September 01, 2009 7:52 PM

Hi,

Do you mean you want to compare procedure scriptsstored in VSS with the one in your SQL Server database? As far as Iknow, VSS does not provide any method toachieve this.

Catherine Sea
Version Control Software | Software Configuration Management Solution

Marked As Answer byWesley YaoMSFT, ModeratorWednesday, September 09, 2009 2:46 AM

Catherine Sea Thursday, September 03, 2009 5:59 AM

You can check this article:

http://msdn.microsoft.com/en-us/library/ms181089(VS.80).aspx

Catherine Sea
Version ControlSoftware |Software Configuration ManagementSolution

Marked As Answer byWesley YaoMSFT, ModeratorWednesday, September 09, 2009 2:46 AM

Catherine Sea Friday, September 04, 2009 10:41 AM

Hi,

Do you mean you want to compare procedure scriptsstored in VSS with the one in your SQL Server database? As far as Iknow, VSS does not provide any method toachieve this.

Catherine Sea
Version Control Software | Software Configuration Management Solution