sql - share datas between 4 websites -


i'm planing webproject, containing 4 websites build in mvc3. databaseserver i'm going use ms sql server.

each of websites have arround 40 tables. of tables shared between websites: contact, cities, postalcodes, countries...

how handle this? should put tables of each database common database (so database of website 1,2,3 , website 4 in 1 databse together). or should create 1 database containing shared datase?

but think i'm getting problems data consitency, because think there no way point 1 database other (linking example citytable in database 1 buldingtable in databse 2).

any ideas? lot!

what splitting out separate databases if each web site has own database, , 1 of web sites gets extremely popular, easy move database different, more powerful database server , not has change except (a) need reference central "control" data remotely (or replicate/mirror/etc), , (b) point web site @ different database server. benefit if 2 web sites have same types of tables (e.g. patients), don't have have tables patients_website1, patients_website2, different stored procedures identical except table names (or ugly dynamic sql procedures paste table name in). separated out can have exact same schema , exact same codebase without having combine everyone's data single table.

if mix data within single database, data consistency easier, , whole setup simpler, splitting out when grow lot tougher. if split out different databases, no won't able enforce referential integrity using standard dri (foreign keys). can accomplish in other ways if important (triggers, validation before insert/update, etc).


Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more