Category Archives: Transactional Replication

Add a table to an Existing Transactional Replication using T-SQL and Generate Snapshot using T-SQL

Replace the PublishedDB with your published database and TableName with the table name you want to replicate The next step is to start the snapshot agent to pick up the new tables added to replication and replicate across to Subscriber … Continue reading

Posted in Replication, SQL Server, T-SQL Scripts, Transactional Replication, Tricks | Leave a comment

Database Migration Automated

Its been a while since I posted anything here… Phew… Finishing a very tight deadline and critical Database Migration Project today. I have done myself some justification by automating the Database Migration work, that would otherwise require me to perform … Continue reading

Posted in .bat scripts, LogShipping, Replication, RoboCopy, Setup, SQL Server, SSIS, T-SQL Scripts, Transactional Replication, upgrade | Tagged , , , | Leave a comment