Friday, March 9, 2012

replication of a database

I requested the help to do a replication of a database.
We consulted Books Online, and other books, and we began to set up her
replies.
We are coming across the following situation:
in all the read examples several servers exist, and in our case we want to
create her he/she replies inside of the same server, because, we would like
to increase tables and consultations in this new database.
We defined although we want a replication Transational, without filters.
We thanked.I understand your question as "Can I replicate between two databases inside the sqme SQL Server?".
The answer is yes.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Frank Dulk" <fdulk@.bol.com.br> wrote in message news:eXVqoHFaDHA.1940@.TK2MSFTNGP10.phx.gbl...
> I requested the help to do a replication of a database.
> We consulted Books Online, and other books, and we began to set up her
> replies.
> We are coming across the following situation:
> in all the read examples several servers exist, and in our case we want to
> create her he/she replies inside of the same server, because, we would like
> to increase tables and consultations in this new database.
> We defined although we want a replication Transational, without filters.
> We thanked.
>|||How?
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:uIdyVaHaDHA.652@.TK2MSFTNGP10.phx.gbl...
> I understand your question as "Can I replicate between two databases
inside the sqme SQL Server?".
> The answer is yes.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
> "Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:eXVqoHFaDHA.1940@.TK2MSFTNGP10.phx.gbl...
> > I requested the help to do a replication of a database.
> > We consulted Books Online, and other books, and we began to set up her
> > replies.
> > We are coming across the following situation:
> > in all the read examples several servers exist, and in our case we want
to
> > create her he/she replies inside of the same server, because, we would
like
> > to increase tables and consultations in this new database.
> > We defined although we want a replication Transational, without filters.
> > We thanked.
> >
> >
>|||The publication, subscriber and distribution all can
reside on the same server. The setup procedure is same as
for multiple servers but you will use the same server name
for all the three roles(publisher,subscriber and
distributor.
Hope to help.
>--Original Message--
>How?
>"Tibor Karaszi"
<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
>wrote in message
news:uIdyVaHaDHA.652@.TK2MSFTNGP10.phx.gbl...
>> I understand your question as "Can I replicate between
two databases
>inside the sqme SQL Server?".
>> The answer is yes.
>> --
>> Tibor Karaszi, SQL Server MVP
>> Archive at: http://groups.google.com/groups?oi=djq&as
>ugroup=microsoft.public.sqlserver
>>
>> "Frank Dulk" <fdulk@.bol.com.br> wrote in message
>news:eXVqoHFaDHA.1940@.TK2MSFTNGP10.phx.gbl...
>> > I requested the help to do a replication of a
database.
>> > We consulted Books Online, and other books, and we
began to set up her
>> > replies.
>> > We are coming across the following situation:
>> > in all the read examples several servers exist, and
in our case we want
>to
>> > create her he/she replies inside of the same server,
because, we would
>like
>> > to increase tables and consultations in this new
database.
>> > We defined although we want a replication
Transational, without filters.
>> > We thanked.
>> >
>> >
>>
>
>.
>

No comments:

Post a Comment