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