Consolidation of database
-
:)Hi The situation i m facing is - i have several databases of lower level shops which needed to be consolidated on regional level, shops' DB will be ported on the regional HQ n on the basis of databases imported, reports will be generated. Well, do u guys have any experiance of such situation or if you can suggest me some link which describes such situation in form of case study or whatever. Thanks in advance Utsav Verma
-
:)Hi The situation i m facing is - i have several databases of lower level shops which needed to be consolidated on regional level, shops' DB will be ported on the regional HQ n on the basis of databases imported, reports will be generated. Well, do u guys have any experiance of such situation or if you can suggest me some link which describes such situation in form of case study or whatever. Thanks in advance Utsav Verma
This setuation seems to need replication check this for information about SQL Server replication http://www.mssqlcity.com/Articles/Replic/Replic.htm[^]