Have a look at the sample chap in my sig. It explains how to replicate to Oracle. To replicate to SQL from Oracle I believe you need the Oracle transparent...

Use transactional replication with the concurrent snapshot option. This will minimize the locks held on your erp database so that the users can continue to work on it.

You need PK's...

Its a fixed limit.

--

Hilary Cotter

Looking for a SQL Server replication book?

http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS

http://www.indexserverfaq.com

I am confused with your requirements. You say the static data available on the child sides needs to be available at the child sites and kept in sync with the...

I am confused with your requirements. You say the static data available on the child sides needs to be available at the child sites and kept in sync with the...

use SQL Authentication. If you are using Replication ActiveX objects you need the following

Publisher account - should be in the PAL - in the publisher

Distributor account - should be in...

I've seen this problem somewhat frequently. The solution is to do a DBCC CHECKALLOC

    ( 'database_name' ,  REPAIR_ALLOW_DATA_LOSS )    

--

Hilary Cotter

Looking for a SQL Server...

I am talking about the distribution database

Another point, set your retention period to something smaller than the 14 days for your publications if you...

You need to put the schema in place the way you want it on the subscriber and use the not for replication setting for all of your identity columns, triggers...

this problem is transitory. Most of the time is will clear next time you run the agent.

--

Hilary Cotter

Looking for a SQL Server replication book?

http://www.nwsu.com/0974973602.html

Looking for a FAQ on...

try to disable replication through the gui and try to enable it again.

--

Hilary Cotter

Looking for a SQL Server replication book?

http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS

http://www.indexserverfaq.com

best policy is to use replication monitor group. Add all the distributors you want to monitor, and if there are any failures you can tell at a glance where they...

sp_changemergefilter

--

Hilary Cotter

Looking for a SQL Server replication book?

http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS

http://www.indexserverfaq.com

it needs to be in the PAL, and have read rights to your snapshot share.

--

Hilary Cotter

Looking for a SQL Server replication book?

http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL...

dbcc opentran

I normally run my db's in full recovery model, dump every 5 minutes, and shrink the tlog. This prevents the ballooning tlogs, and autogrow of them.

--

Hilary Cotter

Looking for...