Trust me, it is not there. The v first thing which I did was unchecking the old server and using the new server.

Hello,

Thanks for the response. The old publisher/subscriber are no longer visible under the Replication folders in SSMS. But in repl monitor I still see the old subscription. I...

I ran the job to clean up expired subscription (sp_expired_subscription_cleanup), still I see the stale subscriptions

Any advise how to clean them from repl monitor?

Using this approach I removed the stale publisher...but not sure how to clean the wrong entry (push subscriber) appearing in Repl Monitor. Though in subscriber side I do not...

Microsoft Support Engineer suggested to run DTA to get a feeling about the indexes.

Note: there was no impact on CPU/memory on the server. CPU was tingling below 30%

Alright. I just fixed it.

Want to convert SQL Server Scripts (functions, procs, triggers and related scripts) from MS SQL DB to MYSQL. These scripts are used for general DB maintenance purposes , say checkdb...

But over a period new login accounts will be created/ old accounts will be dropped.

In terms of matching user permissions, how it is possible without doing any failover? For exa, one can create a job to transfer login and users but in order to...