shared data between two databases

• Olja Dimitrijevic

  Ten Centuries

  Points: 1010

  More actions

  September 1, 2006 at 1:05 pm

  #94535

  I have a database where were we have our user and  client data. I am developing an application that will have a separate database but would like to create referential integrity on the user and client data residing in the first one. What is the best strategy for doing this? Both databases reside on the same 2005 Sql Server.

  Initially I thought that using views referencing the DB1 tables would do the trick since they allow modification and updates but it is not possible to create a foreign key on a view so this is an issue.

  Thanks!

  Olja

• Chris Chilvers

  SSCrazy

  Points: 2260

  More actions

  September 4, 2006 at 5:32 am

  #658283

  The only way I can think of doing this is to use triggers.