I'm looking for something that will tell me the DDL differences between
instances of a database (dev/qa/prod/sandbox) and something to apply a
version number to it. Perhaps with SourceSafe intagration?Hello JayKon,
> I'm looking for something that will tell me the DDL differences
> between instances of a database (dev/qa/prod/sandbox) and something to
> apply a version number to it. Perhaps with SourceSafe intagration?
>
For SQL Server you should take a look at
-Visual Studio Team Edition for Database professionals (integrates in VS,
so has source control support)
- Red-Gate SQL Compare (great tool, but last version I tried (4.0) had no
source control support.
- EMS DB Compare for * (also a great tool, available for multiple database
types (mysql, mssql, oracle, postgesql, firebird, sybase)
You can also directly integrate your database project in Management Studio
with source control (not compare schema's though).
Jesse|||Apex SQL diff also has a nice interface for comaparing and syncronizing. I
was having issues with VS Team Edition, but I didnt really give it much of a
chance yet.
"Jesse Houwing" wrote:
> Hello JayKon,
>
> For SQL Server you should take a look at
> -Visual Studio Team Edition for Database professionals (integrates in VS,
> so has source control support)
> - Red-Gate SQL Compare (great tool, but last version I tried (4.0) had no
> source control support.
> - EMS DB Compare for * (also a great tool, available for multiple database
> types (mysql, mssql, oracle, postgesql, firebird, sybase)
> You can also directly integrate your database project in Management Studio
> with source control (not compare schema's though).
> Jesse
>
>|||While 3rd party products are OK, I was hoping for some SQL someone had
already written. The task doesn't seem hard, just time consuming.
"JayKon" wrote:
> I'm looking for something that will tell me the DDL differences between
> instances of a database (dev/qa/prod/sandbox) and something to apply a
> version number to it. Perhaps with SourceSafe intagration?|||> While 3rd party products are OK, I was hoping for some SQL someone had
> already written. The task doesn't seem hard, just time consuming.
Yes, but why not utilize a product that doesn't constitute re-inventing the
wheel? SQL Compare is $400. The amount of time you would spend perfecting
someone else's SQL scripts to meet your requirements (and not getting any
official support while doing so), even if you are very good, would easily
exceed that on the first day. It's easy to say "there is no budget" but
man-hours have to be quantified as money as well, unless you don't value
your time.
Anyway, if you're dead-set on doing it yourself, have a look at:
http://databases.aspfaq.com/general...r />
se-s.html
After a few hours, if you are frustrated, there are several 3rd party tools
that will be up and running in minutes. SQL Compare has my 100%
endorsement, and the tool from Apex has received great reviews as well. You
can always try them for 14 days to see if they do a better job than your own
scripts. However, as SQL Server continues to get more complex, my guess is
that may not be enough time to finish your own version.
Aaron Bertrand
SQL Server MVP|||On Aug 10, 1:16 pm, "Aaron Bertrand [SQL Server MVP]"
<ten...@.dnartreb.noraa> wrote:
> Yes, but why not utilize a product that doesn't constitute re-inventing th
e
> wheel? SQLCompareis $400. The amount of time you would spend perfecting
> someone else'sSQLscripts to meet your requirements (and not getting any
> official support while doing so), even if you are very good, would easily
> exceed that on the first day. It's easy to say "there is no budget" but
> man-hours have to be quantified as money as well, unless you don't value
> your time.
> Anyway, if you're dead-set on doing it yourself, have a look at:http://databases
.aspfaq.com...pare-my-sql-...
> After a few hours, if you are frustrated, there are several 3rd party tool
s
> that will be up and running in minutes. SQLComparehas my 100%
> endorsement, and the tool from Apex has received great reviews as well. Y
ou
> can always try them for 14 days to see if they do a better job than your o
wn
> scripts. However, asSQLServercontinues to get more complex, my guess is
> that may not be enough time to finish your own version.
> --
> Aaron BertrandSQLServerMVP
Even better, xSQL Software (http://www.xsqlsoftware.com) has a
completely free lite edition of its xSQL Object that does what you
need. And, if you want to tweak things yourself you can check out xSQL
SDK it comes with a thorough documentation and easy to follow
samples.
Thanks,
JC
xSQL Software
http://www.xsqlsoftware.com|||www.dbconstructor.com
If you would like I can show you how to do it using the above tool.
Regards,
Rober Allen Schambach
"JayKon" <JayKon@.discussions.microsoft.com> wrote in message
news:80C2CA91-7FA4-4035-B9B8-59D8E8D66E65@.microsoft.com...
> I'm looking for something that will tell me the DDL differences between
> instances of a database (dev/qa/prod/sandbox) and something to apply a
> version number to it. Perhaps with SourceSafe intagration?
