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
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...
>
>
Showing posts with label locations. Show all posts
Showing posts with label locations. Show all posts
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...
> >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
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...
> 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...
>> >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,
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...
> > 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...
> >> >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
> >>
> >>
> >>
>
>
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...
> >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
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...
> 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...
>> >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,
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...
> > 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...
> >> >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
> >>
> >>
> >>
>
>
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...
>
>
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...
>
>
Wednesday, March 7, 2012
Displaying Backup file locations
Hi,
I have an application that I want to allow a user to backup their sql 2005 database. I use the SMO classes to actually perform the backup, but my application can run on a client machine, not just the database server. As I allow the user to select the location for their backup I would really like to show a folder list of server locations, not local (i.e. client) folders.
Basically I wondered if there were any UI objects available for Sql 2005 ( in the SMO namespaces perhaps), something that will display a list of server folders and could be used from a client machine.
Thanks for your help
Graham
You can get the server's default backup directory within SMO from the server's .Settings.BackupDirectory property. You should be able to find other directories using WMI queries, I'd think.
|||As Allan said, this is done through WMI.HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
Subscribe to:
Posts (Atom)