Hi there. I want to try set up merge replication from one machine to another, but I dont want to bulk copy the tables as the data already exists in the other database. Ive been testing the scenario out on a basic DB. It has one table and has a uniqueidentifier and another char col. The other database I am replicating to has exactly the same data. The create tasble statement is here:
CREATE TABLE [dbo].[testTable] (
[rowGUID] uniqueidentifier ROWGUIDCOL NOT NULL ,
[val] [char] (10) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]
When I try to start synchronising I get the following error:
Invalid column name 'rowguidcol'.
Any ideas on this?? On the real database all my tables use Uniqueidentifiers as the primary key just like the table above...