Thursday, March 29, 2012

distributed database

i have same sql server database located in 3 different locations.in addition
i want to have a central database having all the data from these 3 different
locations online.
how i can achieve this with out writing code or exporting data ?or any other
way.
pls adviceHi
SQL Server Replication would be the answer, but that generally involves
changes to the table structures unless the application was designed for it.
Have a look at http://www.mssqlserver.com/replication/primer_p1.asp
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote in
message news:9E26F443-FC72-4E1F-BC81-8098836720B1@.microsoft.com...
>i have same sql server database located in 3 different locations.in
>addition
> i want to have a central database having all the data from these 3
> different
> locations online.
> how i can achieve this with out writing code or exporting data ?or any
> other
> way.
> pls advice|||Hi Mike,
my requirement is to have all the data in headquarters from region 1, region
2 and region 3 online.
what kind of replication i can use.
can you pls elaborate.
Thanks in advance.
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> SQL Server Replication would be the answer, but that generally involves
> changes to the table structures unless the application was designed for it
.
> Have a look at http://www.mssqlserver.com/replication/primer_p1.asp
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote in
> message news:9E26F443-FC72-4E1F-BC81-8098836720B1@.microsoft.com...
>
>|||Hi
It all depends on your table structure, bandwidth and transactional volume,
but since we don't have that information, we can't guess.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote in
message news:27497750-0273-498D-BCBE-524881341766@.microsoft.com...[vbcol=seagreen]
> Hi Mike,
> my requirement is to have all the data in headquarters from region 1,
> region
> 2 and region 3 online.
> what kind of replication i can use.
> can you pls elaborate.
> Thanks in advance.
> "Mike Epprecht (SQL MVP)" wrote:
>|||Hi Mike,
transactional volume will be 5 mb per day per regions and bandwidth 1 mb
what kind of replication i can use merge replication or transactional
replication.
pls advice
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> It all depends on your table structure, bandwidth and transactional volume
,
> but since we don't have that information, we can't guess.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote in
> message news:27497750-0273-498D-BCBE-524881341766@.microsoft.com...
>
>

No comments:

Post a Comment