Fucking SIGH. Was just about to kick off a project using the fucking redgate comparison SDK for this.
Fuck it, we'll query the system tables on the databases and sort it out ourselves.
I'm sitting at the office doing exactly that for indexes anyway.
Apparently I'm not allowed to build anything these days without resorting to engineering from first principles.
Fortunately, if you only care about stored procedures, views, functions, tables, those principles are pretty easy.
Yup. If your company's budget or any reason pervert you to buy and use ready-to-use solution, it doesn't harm to write one yourself.
Afterall, MSSQL now supports INFORMATION_SCHEMA. If you care only after ordinary things like table/view/stored proc/function, it ought to be easy,
We actually procured the Redgate SDK a few years back. As with all maintenance-and-process related things in my development backlog, it has been eternally on hold pending the completion of pointless shit that seagull management wants.
We were about to kick off the project finally because my boss managed to shake loose the entire maintenance-and-process queue by mentioning some items in it to the VP during an escalation over some preventable incident, so my director is now feeling pressure from above to let us fix shit we could have fixed years ago.