Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


Visual Studio 2010 and SQL Server Tutorial

By:   |   Last Updated: 2012-10-08   |   Comments (3)   |   Related Tips: More > Application Development

Visual Studio 2010 and SQL Server Tutorial

Read the tutorial!

One of the more difficult jobs that database professionals have to endure is maintaining installation and upgrade scripts for their databases from release to release. Many methods and tools are used such as loose SQL scripts run via SQLCMD or even writing a homegrown system to handle the creating and upgrading of databases. The biggest headaches are making sure dependencies among objects are observed so an install or upgrade does not fail and also to create scripts to update a database from a previous schema version to the latest. These processes are usually manual and they can be labor intensive. Unfortunately, this also means that they can be prone to error.

Read the tutorial!

Last Updated: 2012-10-08

get scripts

next tip button

About the author
MSSQLTips author Armando Prato Armando Prato has close to 30 years of industry experience and has been working with SQL Server since version 6.5.

View all my tips

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Tuesday, March 03, 2015 - 12:23:46 AM - laylay,wilfredo Back To Top

**how to connect sql manager to visual basic 2010***

Wednesday, April 24, 2013 - 7:50:21 AM - Edson Back To Top


   I have a program wtih visual Basic 5 using SQL statements and a Access database.

   I'm trying to converte the program to Visual Studio 10 using the same database.

   Is there a tip, table of converter, and so on to help to do this?

   I have founded a lot of erros and I would like to fix all of them.


Thanks a lot





Friday, January 04, 2013 - 9:15:41 PM - Bill Crud Back To Top

I must say this SQL multiple conditions tutorial was excellent. Thank you for posting it.

Learn more about SQL Server tools