|
Home > Archive > MS SQL Server > August 2005 > Unifying SQL databases from different regions
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Unifying SQL databases from different regions
|
|
|
| Hi
We have data collected in 3 different regions each region having its own
database servers. Now we have a requirement to merge all these data to single
location with one database server being used to store and manage data.
Regarding this what are the questions I need to ask for and what are the
issues that might come and how we need to plan with respect to CPU, disk
space, performance etc. Please help me. In case you have any sites which
gives pointers to my question please provide them to me.
Thanks, gk
| |
| Srihari 2005-08-09, 3:23 am |
| Hi gk,
If you are using sqlserver2005 then Partitioning is the best solution for
this. While merging the data make use of region identification and then
partition the data accordingly.
There is other method if you are not going for sqlserver2005 then i feel you
can use linked servers.
With Regards,
AHARI
"gk" wrote:
> Hi
>
> We have data collected in 3 different regions each region having its own
> database servers. Now we have a requirement to merge all these data to single
> location with one database server being used to store and manage data.
> Regarding this what are the questions I need to ask for and what are the
> issues that might come and how we need to plan with respect to CPU, disk
> space, performance etc. Please help me. In case you have any sites which
> gives pointers to my question please provide them to me.
>
> Thanks, gk
| |
| Uri Dimant 2005-08-09, 3:23 am |
| gk
Are those three database have the same structure? If they aren't you will
probably set to a new database's design to transfer some/ or all tables.
Finally , can you provide a little bit more info about the issu?
"gk" <gk@discussions.microsoft.com> wrote in message
news:B0584F38-017C-4835-BBA8- 1928B0E410A0@microso
ft.com...
> Hi
>
> We have data collected in 3 different regions each region having its own
> database servers. Now we have a requirement to merge all these data to
> single
> location with one database server being used to store and manage data.
> Regarding this what are the questions I need to ask for and what are the
> issues that might come and how we need to plan with respect to CPU, disk
> space, performance etc. Please help me. In case you have any sites which
> gives pointers to my question please provide them to me.
>
> Thanks, gk
|
|
|
|
|