Re: Last Modified Date of table, queries, views, sprocs

On Oct 29, 4:23 pm, "Aaron Bertrand [SQL Server MVP]"
<ten....@xxxxxxxxxxxxxx> wrote:
WhileRed Gate'sSQL Compare can save you after the fact, the true answer
is that all objects should be kept under version control, and you check
out the objects as you need to change them. Once you are done, you check
in the changes. Then you can extract the changed files by seeing what
has changed since the previous baseline.

That works for stored procedures but it can be harder to do for tables, e.g.
if you add indexes, change column datatypes, etc. What do you store? A new
CREATE TABLE script? What good does that do you?

Red-Gate allows you to compare your test and production systems, build a
script that will synchronize them, and then store THAT in source control.

All depends on what you're after, I guess. Personally I don't consider SQL
Compare an "after the fact" tool.

Aaron

Hi Aaron,

SQL Compare 6 Pro (released in June) is now not only able to compare a
live database, but also to compare a database's schema creation
scripts with a target database to generate a SQL change script. So in
theory it is possible to maintain the table creation scripts and
nothing more. Of course there are some situations where this doesn't
work, for example if a significant change has been made to the target
database, such as a table split or an object rename. However, this is
no different to problems encountered comparing two live databases
where one has been significantly changed or refactored.

Kind regards,

David Atkinson
Red Gate Software


.

Relevant Pages

  • Re: Last Modified Date of table, queries, views, sprocs
    ... CREATE TABLE script? ... and then store THAT in source control. ... Compare an "after the fact" tool. ...
    (microsoft.public.sqlserver.tools)
  • Re: Freeware 32bit command line hardware detector?
    ... for the purpose of creating a hardware independent Windows XP Ghost ... or whatever I could compare against) and then the ... script would know which HAL to copy into windows\system32 and then the ...
    (microsoft.public.windowsxp.general)
  • Re: Which test to use?
    ... 50 rats were made diabetic and compared with 50 ... I would like to compare the ... measurements in each of the 6 regions between the diabetic and control ...
    (sci.stat.math)
  • Re: Simple? Query the contents of an Imagebox
    ... the images within the control ... cannot compare the image to it's original value. ... Public Function CompareTwoImages(ByRef image1 As Image, ... Dim img1 As New Bitmap ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Perl script to mimic uniq
    ... > That is not what Unix uniq does. ... Can I se this script to compare the n columns of a file, ... > I suspect there's more to your original problem than you are telling ...
    (comp.lang.perl)