If the issue here is that dev and prod are in different environments in which you can't do a comparison directly because of network restrictions, then the best option would be to capture a snapshot from one of the sources and use that. the stuff we do have in source control we are using Visual Studio database projects and we still gets tonnes of drift so the above would still be nice features to have. I've created the user voice below - just wondering if anyone had any advice.Īt the moment i have to export and use winmerge on the 2 different files. They are producing different results and I want to refine the newer one whilst having the production one as a baseline. dbo.usp_StoredProc_New and dbo.usp_StoredProc_current. I am testing on the same environment and am doing regression testing on two procs. I want to quickly compare dbo.usp_SomeStoredProc on dev with the one in production.Ģ. management always say the same thing, "it won't be here in a couple of months so not worth the effort." and then 2 years pass and they still say the same thing.ġ. I can do this very nicely with SQL Source control but a lot of our legacy stuff we've inherited isnt in source control at the moment. Hi - is there a way to quickly compare two objects.
0 kommentar(er)
