SQL Server Performance

Synchronize DataBases Structures

Discussion in 'SQL Server 2008 General DBA Questions' started by AMOURGH, Jul 13, 2009.

  1. AMOURGH Member

    Hi sql-server-performance, I wonder if there is something in sql server that can enable me to automatically create objects in other database when i create them in a fixed database(synchronizing DataBases structures !!). Have many databases:the reference database RefDb and other database :Db1,Db2,Db3. Examples:if i add a stored proc Proc1 in RefDb ==>Proc1 is created automatically in Db1,Db2,Db3. Create table Table1 in RefDb==>Table1 is created automatically in Db1,Db2,Db3. At the moment i use MS VS team system ,compare schemas,update,...But it s boring !!Thanks for advance,Rachid
  2. satya Moderator

    It can be achieved with the triggers but at the same time think about scalability of creating multiple objects at the same time.
    That is why TFS (Team Foundation system) is good enough to cater your need, though you say it is boring.

Share This Page