Have Geek Brain

SQL Server Version Upgrade Tables

I am part of a software development company looking for a good way to update my SQL Server tables when I release a new version of the software. I know the answer is probably to use scripts in one form or another.

I am considering writing my own .NET program that runs scripts to make it a little easier and more convenient. I was wondering if there are any tools out there in this direction. Any input would be appreciated.

0


a source to share


5 answers


Suggest you take a look at Red_gate SQlCompare



+1


a source


What product are you using to install your software? Products like InstallShield often include SQL steps as an option to part of your installation script.

Otherwise, you can use isql / osql to run your script from the command line via a batch file.



One of the developers I'm currently consulting with wrote a pretty great SQL installer. I'll ask him when he finds out how he did it.

+1


a source


I use Red Gate SQL Compare all the time. Also you need to ensure that the script is rolled back if you need to revert to a previous version.

+1


a source


Check out DB Ghost Packager Plus .

Packages the source database and compare and sync engine into a simple EXE for deployment. The EXE installer will automatically update any target schema to match the source on the fly during installation.

0


a source


Red Gate SQL Compare to generate change script and Red Gate Multi Script to easily send it to multiple SQL databases at the same time.

0


a source






More articles:


All Articles