Is there a way to compare a script in Visual source safe with sql 2005 stored procedure without scripting out the stored procedure from sql? I usaually script out a stored procedure from sql to a .sql file and compare it with a script in VSS and I was wondering if anyone know a faster way to compare SPs in production server with VSS. I am using sql management studio and also added all SPs to VSS thru management studio. Thanks.
Hi,
the best application for this is the Visual Studio for Database professionals. The sources used here can be integrated with a Visual Source safe provider. You can easily compare two database /the actual project in schema as well as in the data.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment