Apr 30, 2012 09:12 AM|reza141414|LINK
i have web app with sql database.
i sell my app to diffrent customers.
now i have one customer that he want to buy 2 app (app1&db1----app2&db2)...it's well. but my problem is here that:
i have Emp table in my database that store Employee information.
for this customer i need 2 database for 2 app but i need the Emp table be the same in 2 database.
i search diffrent solutin and i need some help to use best solution:
1- using trigger to sync 2 tbl in 2 database==> it's not good becuse data in Emp tbl are too many and storing these data in 2 place is not googd suggestion.is't it?
2- access the Emp tbl data in only 1 database(using lnked server in sql server) ==> in this way i shuold change lots of my code...
i'm looking for a solution that i can have virtual table in db2 that is pointer to the Emp.db1!!!
is it possible?
any suggestion plz?