How to work with databases
-
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
Thank you to anyone taking the time to read my posts.
-
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
Thank you to anyone taking the time to read my posts.
Patrick Skelton wrote:
it's easy to create a new database in Visual Studio, but how do I then get this onto my web hosting server?
That depends on your hosting company. The obvious options would be:
- Backup your local copy of the database, copy the files to the server, and restore;
- Use the "Generate Scripts" option to create a SQL script which you can run on the server to create the database;
- If the host supports it, use Web Deploy[^];
Patrick Skelton wrote:
How do I make sure I can repeat this process if need be?
If you're overwriting the remote copy of the database, it's simply a case of repeating the initial deployment. If you just want to deploy structural changes, you'll need to create the SQL scripts to make the changes on the server.
Patrick Skelton wrote:
Can I create a new database with the same schema as an existing one?
Schemas are local to the database. Two schemas in different databases with the same name are not connected in any way.
Patrick Skelton wrote:
s there a recognised way to set up the tables and relationships used by the security classes built into .NET?
If you're using the SQL providers, then the ASP.NET SQL Server Registration Tool[^] is the way to go. However, these providers are quite old; you might prefer to look at the newer "Universal" providers[^]. As for your broader question, I presume you've looked at the SQL documentation on Technet[
-
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
Thank you to anyone taking the time to read my posts.
-
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
Thank you to anyone taking the time to read my posts.
Sage advice from both Patrick and j, I presume you are having trouble finding reference on developing sql server[^] Also sqlservercentral.com[^] is a good resource but they tend more towards the DBA skills. As a one man show you are going to have to get a good handle on the development cycle, building the app is only the core skill. POH has some excellent articles [^]you may be interested in
Never underestimate the power of human stupidity RAH
-
Patrick Skelton wrote:
Does anyone know where to find information how to develop on MSSQL?
I buy books.
Okay - can you recommend any good books?
Thank you to anyone taking the time to read my posts.
-
Patrick Skelton wrote:
it's easy to create a new database in Visual Studio, but how do I then get this onto my web hosting server?
That depends on your hosting company. The obvious options would be:
- Backup your local copy of the database, copy the files to the server, and restore;
- Use the "Generate Scripts" option to create a SQL script which you can run on the server to create the database;
- If the host supports it, use Web Deploy[^];
Patrick Skelton wrote:
How do I make sure I can repeat this process if need be?
If you're overwriting the remote copy of the database, it's simply a case of repeating the initial deployment. If you just want to deploy structural changes, you'll need to create the SQL scripts to make the changes on the server.
Patrick Skelton wrote:
Can I create a new database with the same schema as an existing one?
Schemas are local to the database. Two schemas in different databases with the same name are not connected in any way.
Patrick Skelton wrote:
s there a recognised way to set up the tables and relationships used by the security classes built into .NET?
If you're using the SQL providers, then the ASP.NET SQL Server Registration Tool[^] is the way to go. However, these providers are quite old; you might prefer to look at the newer "Universal" providers[^]. As for your broader question, I presume you've looked at the SQL documentation on Technet[
Thank you for taking the time to write that reply. I will dive in with your suggestions. - Patrick
Thank you to anyone taking the time to read my posts.
