Database validator

Topics: Installing BugNET
Jul 3, 2012 at 4:20 PM

I was wondering if there is anyway I can easily check if my database is valid. I was working with the latest version for some time and then I found out some storedprocedures were missing. With the provided sql file I added them manualy but now I'm unsure if everything is added properly.

My guess is that something went wrong during installation. 

What I could do is create a new installation of the latest version and then use SQL Compare to check if everything is there, but if some installation script is malfunctioning this would give no result. 

Jul 9, 2012 at 2:15 PM

Not really, the database install script is the best way to verify the database is up to date.

Jul 13, 2012 at 10:51 AM

Can i safely execute such a script? In a live database? Because previous scripts have failed, executing the database install script may give errors?