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
> >>
> >>
> >>
>
>

Displying rtf database field properly formatted

I am a simple user- I have a SQL Server database that stores a particular field as rtf, including all of the formatting characters in addition to the actual user-entered text.

I use the report wizard to easily build reports, but this particular field outputs all of the gobbldygook but I just want the user-entered text.

Crystal Reports easily translates rtf- why can't Microsoft easily translate their own format? Any help would be appreciated.

Hi kc,

This is a feature we are looking at for later releases. We want something like this too.

sql