StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>There are obviously a number of ways to approach this, so I am going to list a number of links that should provide a better foundation to build on. These are the links that I've referenced in the past when trying to get others on the bandwagon.</p> <ul> <li><a href="http://aspnet.4guysfromrolla.com/articles/071305-1.aspx" rel="noreferrer">Database Projects in Visual Studio .NET</a></li> <li><a href="http://www.ssw.com.au/SSW/Standards/Rules/DataSchemaStandard.aspx" rel="noreferrer">Data Schema - How Changes are to be Implemented</a></li> <li><a href="http://www.codinghorror.com/blog/archives/000743.html" rel="noreferrer">Is Your Database Under Version Control?</a></li> <li><a href="http://www.codinghorror.com/blog/archives/001050.html" rel="noreferrer">Get Your Database Under Version Control</a></li> <li>Also look for MSDN Webcast: Visual Studio 2005 Team Edition for Database Professionals (Part 4 of 4): Schema Source and Version Control</li> </ul> <p>However, with all of that said, if you don't think that you are committed enough to implement some type of version control (either manual or semi-automated), then I HIGHLY recommend you check out the following:</p> <ul> <li><a href="http://www.red-gate.com/products/SQL_Compare/index.htm" rel="noreferrer">Red Gate SQL Compare</a></li> <li><a href="http://www.red-gate.com/products/SQL_Data_Compare/index.htm" rel="noreferrer">Red Gate SQL Data Compare</a></li> </ul> <p>Holy cow! Talk about making life easy! I had a project get away from me and had multiple people in making schema changes and had to keep multiple environments in sync. It was trivial to point the Red Gate products at two databases and see the differences and then sync them up.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload