December 5, 2016 at 2:25 pm
I believe I've got everything setup properly from the Oracle side as I can connect, and when create an Oracle Publisher and providing the connection details it finds all my tables.
When I pick one that I want to test for publication, I get:
Constraint column '<PRIMARY_KEY_COL>' not found in table '<TABLE_NAME>'. Changed database context to 'distribution'. (Microsoft SQL Server. Error: 21613)
(Where <PRIMARY_KEY_COL> is the actual name of the Primary Key column and <TABLE_NAME> is the Table name I'm using as a test from Oracle, so it's finding the right information).
Most google searches are for MS SQL 2005/2008 and tell the people complaining to upgrade to a service pack. I'm on SQL Server 2014 Enterprise Edition.
This is a new publication when I'm adding just one table (for starters). I'm able to connect to the database from sqlplus on the SQL Server machine with no issues.
Any ideas what I've missed?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply