hi all,
I have a single sql server, and two databases with similar
table names and structures for some 10-15 tables.
I want replicate the data from one db to another to keep
them in sync.
Can I do this using replication ?
Is replication possible between two db's of a single
server ?
I tried already it gives an error 18483 could not connect
to server cause distributor_admin is not defined as a
remote login at the server ?
thanks in advance
You can replicate to the same server. TO fix your distributor_admin problem
disable replication and re enable it.
This normally fixes this problem.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"San" <anonymous@.discussions.microsoft.com> wrote in message
news:007201c4dc8a$e52018a0$a401280a@.phx.gbl...
> hi all,
> I have a single sql server, and two databases with similar
> table names and structures for some 10-15 tables.
> I want replicate the data from one db to another to keep
> them in sync.
> Can I do this using replication ?
> Is replication possible between two db's of a single
> server ?
> I tried already it gives an error 18483 could not connect
> to server cause distributor_admin is not defined as a
> remote login at the server ?
> thanks in advance
Monday, March 19, 2012
can this b done by replication ?
Labels:
10-15,
database,
databases,
microsoft,
mysql,
names,
oracle,
replicate,
replication,
server,
similartable,
single,
sql,
structures,
tables
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment