Schema Replication

• Fawzy Ibrahim

  Newbie

  Points: 1

  More actions

  June 20, 2005 at 10:18 am

  #89845

  Hi Everyone

  I am about to develop an application for schema replication

  Currently I am searching for a way to know that the schema was modified at the modification time.

  Any ideas?

  Thanks

• Paul Ibison

  SSCertifiable

  Points: 5303

  More actions

  June 20, 2005 at 1:27 pm

  #566860

  As we can't put triggers on system tables, I would think that only polling solutions would be applicable.

  Incidentally, you probably know this, but there are already applications (eg Redgate) which will create schema change scripts, and in SQL Server 2005 there is in replication the option to replicate schema changes automatically. Also there are database and server triggers to implement other related solutions.

  Rgds,

  Paul Ibison SQL Server MVP, http://www.replicationanswers.com

    

  
  Paul Ibison
  Paul.Ibison@replicationanswers.com

• mark baekdal-145375

  SSCrazy

  Points: 2200

  More actions

  June 21, 2005 at 12:38 am

  #566936

  we also do an application - DB Ghost - that creates schema and data change scripts with a twist - it works with your source control and the scripts always work - it's all in the way they're created.

  regards,

  Mark Baekdal

  http://www.dbghost.com

  http://www.innovartis.co.uk

  +44 (0)208 241 1762

  Build, Comparison and Synchronization from Source Control = Database change management for SQL Server

   

   

   

• tzara

  Say Hey Kid

  Points: 663

  More actions

  June 21, 2005 at 1:31 pm

  #567210

  i just wrote an shell app to stuff the schema into source safe using DMO.  just an afternooon project, a little longer for all the bells and whistles needed for a large enterprise.

  now we can track changes, on all dev and production servers on the network.