sql server replication: simple one.. on replication -- sql server replication

simple one.. on replication

Hitesh
8/31/2004 2:57:08 PM

sql server replication: Hello ...

I am having a problem ,, where my replication is not working ..
i.e i cannot see the data in the subscriber database.. i think i am missing
something.. the below is my system setup and the steps that i have
folllowed.. can u know if i am missing something?

Here is my sql system back ground..

I have a simple set up.. where there is 1 oltp server and 1 reporting server.

There are a few tables that needs to be REPLICATED to the reporting server
(for current envt both servers are same physical boxes) using replication..

I am using transactional replication.. and have created a the publication,
and distribution databases on the same server..
i have set up the publications and the subscriptions also..
after that i have started the initial snapshot to run copy the initial data
and then started the distribution agent hoping that it will copy the initial
snapshot to the subscriber.. but it does not ...

my first repln setup... is this...
so do u know what i am missing???

Thanks..in advace

RE: simple one.. on replication

Hitesh
8/31/2004 3:07:18 PM

Ok,

Found the problem.. the repln is working.. but it creates new tables with
ownership of dbo.* where as i had existing tables where i was expectiing the
data with ownership of myusername.tablename instead of dbo.tablename....

I will try to modify the repln to save into the tables with myuser,tablename
instead..
ALso need to check if the data in the subscribed database is corrupt as i
had run the initial snapshot twice...

ANy advise? before i fihgure out muself .. willbe appreciated..

[quoted text, click to view]

Re: simple one.. on replication

Hilary Cotter
9/1/2004 8:09:09 AM

Data does not get corrupt as it flows from the publisher to the subscriber.

To fix your problem, in case you haven't figured it out already:)

1) create the account myusername on your subscriber and add it as a database
user on the subscription database.
2) right click on your publication, select properties, click on the articles
tab. For each article, click on the three ellipses and in the destination
owner name type mysuername. Click on OK, Apply, OK, restart your snapshot
agent, and then your distribution agent(s).

--
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.