I am new to SQL Server Replication. I have a scenario where I need to replicate data from one database to another database in the same DB server instance. How easy is this?
What are the steps to follow?
Source DB is having tables with primary key IDENTITY. Target DB is having tables with same structure without Identity for primary key columns.