Click here to Skip to main content
14,457,986 members
Rate this:
Please Sign up or sign in to vote.
Hi,

Apologies for the length of this question.

Does anyone know where to find information how to develop on MSSQL? I'm not looking for information on database design (Normal Forms etc.), but on how you actually work with it. For example, it's easy to create a new database in Visual Studio, but how do I then get this onto my web hosting server? How do I make sure I can repeat this process if need be? Can I create a new database with the same schema as an existing one? Is there a recognised way to set up the tables and relationships used by the security classes built into .NET? The list goes on.

I find information on designing databases everywhere, but I can't find anything good on how you actually work with them day-to-day. What are the best practices? I am a one-man-band, starting a project that uses an MSSQL database, and while the database won't be doing anything 'heavy' initially, I don't want to get into deep water. I'd like to do things 'right'.

Any advice would be gratefully received.

Kind wishes - Patrick
Posted
Comments
Sergey Alexandrovich Kryukov 13-Aug-13 12:22pm
   
Apparently, not a topic for a Quick Answer. You can search for some articles.
—SA
Richard MacCutchan 13-Aug-13 13:22pm
   
You already posted this question at http://www.codeproject.com/Messages/4635679/How-to-work-with-databases.aspx. Please post in one forum only.
Patrick Skelton 13-Aug-13 13:40pm
   
Yes, sorry, but I got the message above, saying that it was not suitable for Quick Answers. Didn't really know what to do. - Patrick

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100