|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Comparing two databasesIs there a way to compare the strored procedure,views and UDF's between two
databases to see if there are any differences. I use one database for developement and the other is online. I would like to be able to run a structural comparison between the two to make sure i didn't forget to script a function or stored procedure after making modifications. I normally just script all objects from developement to online after mods but I would like to know for certain they are both the same sometimes. Also I would like to read up on best practices for tracking developement so if you know of any good reading that would help me. I use MS Access project as a front end and SQL 2000 as the Be. Thanks > Is there a way to compare the strored procedure,views and UDF's between SQL Compare 4.0> two > databases to see if there are any differences. I use one database for > developement and the other is online. I would like to be able to run a > structural comparison between the two to make sure i didn't forget to > script > a function or stored procedure after making modifications. http://www.red-gate.com/ "AkAlan" <AkA***@discussions.microsoft.com> wrote in message We use SQL Delta. Does wonders for our spare time! (maintaining/updating approx. 25 DB news:3A5AF648-8D41-441A-BA91-0EF14B5C09A0@microsoft.com... > Is there a way to compare the strored procedure,views and UDF's between two > databases to see if there are any differences. I use one database for installations) http://www.sqldelta.com You should be checking your development and production scripts into some
type of source version control system. For example, Visual Source Safe has an option to compare two projects and list files that are different, and it has a feature for comparing two versions of a script side by side with differences highlighted. Also, you can script the databases to seperate folders and use a tool like WinMerge to perform the comparisons: http://groups.google.com/group/microsoft.public.sqlserver.programming/msg/ff9cfe0c46abfa76 Rather than scripting all objects from development to production in bulk, you need to identify specific objects that have changed and deploy them individually. There are a number of reasons, but for one, you run the risk of accidentally running a script that drops / recreates a table thus resulting in data loss. Show quote "AkAlan" <AkA***@discussions.microsoft.com> wrote in message news:3A5AF648-8D41-441A-BA91-0EF14B5C09A0@microsoft.com... > Is there a way to compare the strored procedure,views and UDF's between > two > databases to see if there are any differences. I use one database for > developement and the other is online. I would like to be able to run a > structural comparison between the two to make sure i didn't forget to > script > a function or stored procedure after making modifications. I normally just > script all objects from developement to online after mods but I would like > to > know for certain they are both the same sometimes. Also I would like to > read > up on best practices for tracking developement so if you know of any good > reading that would help me. I use MS Access project as a front end and SQL > 2000 as the Be. Thanks  |
|||||||||||||||||||||||
Other interesting topics