Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mazer
Starting Member
2 Posts |
 Posted - 2005-09-11 : 08:42:44
|
| I want to upsize the MS Access database on my web site to MS SQL, but I don't know anything about doing it, can any one tell me if I will need to change the code on my web page aswell? there is a lot of search pages on my site and at the moment there very slow because of the database I'm using. any advice the forum members can give would be greatly appreciated. |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-09-11 : 12:18:57
|
| The best advice I can give is: go to your local library, find a good book on SQL Server, and read it. Make sure you have a fundamental understanding of it, and how it differs from Access, before trying to do too much. |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-09-11 : 12:36:34
|
Are you just upgrading tables, or do you also have procedures, reports, etc in Access you're wanting to upgrade? If it's just the tables, and the website is the only thing accessing them, you will be able to just move the tables over fairly easy for an initial quick gain. You will of course, need to change your connection strings for the website. You can find connection string formats at www.connectionstrings.com. Also, if you are using inline code (my guess), you will need to change all the "Access specific" syntax to SQL Server syntax. While you're doing that, you should just go ahead and make everything use stored procedures and proper security.  I would definitely buy a couple books though and start reading it. You're not just going to want Access in SQL Server. If you're getting big enough that traffic is an issue, you should make sure you have a properly secure and well-designed SQL Server database and environment. I would start by reading here, any buy or loan from the library any books you can find by Ken Henderson and Kalen Delaney.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
|
|
Help - I need SQL but know nothing about it!