My company is trying to establish a centralized database that will push and receive data from application databases.
Currently our centralized database is using auto increment for the primary keys. Some of the application databases use auto increment as well. We are a SQL based company with SQL Server 2000 and 2005.
We were thinking of using merge replication. Our concern is the centralized database and application database will auto increment the same primary keys. Therefore, we may use the GUID as the primary key.
Does anyone have any suggestions on best practices? Any known issues with using the GUID as a primary key? Would service broker be helpful here?