| Author |
 Topic  |
|
|
Astralis
Senior Member
USA
1218 Posts |
 Posted - 29 October 2002 : 17:20:53
|
I'm seeking advice about my website from Snitz and ASP users.
I have compiled a site using several different databases. The site has grown as I've added applications and even more databases.
For example, I have a classifieds section, an article management section, and Snitz all using separate databases.
The problems that I'm having include:
1. Because each section of the website is based on a different database, the look and feel is different for each section. This is not good for business and branding and it's a beast to have to redesign all the pages.
2. I'm using only Access and as it grows I fear that moving to a SQL server will severely cripple my site although staying with Access my cripple it anyhow.
3. I want to share content on all the pages but can't create Syndication javascript for everything. Additionally, I don't know how stable this is.
Solutions:
Some solutions that I've thought of include:
1. Compiling the tables and fields into one database. This is where I need advice. Is this advisable? For Access, will this affect performance? I don't want to separate the site into FRAMES or IFRAMEs for each section - that's asking for trouble.
2. Update to SQL server. I'm not going to do this but I need to think about it. On a scale of 1-10 with one being the least difficult, how difficult is it to convert a site made for Access into SQL? Anywhere links that explains how this is done
3. Can you connect to two or more databases on one ASP page? If so, how is this done?
Any advice on some of the problems I have would be appreciated. |
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 29 October 2002 : 18:16:37
|
1. I put all mine into one database. This means articles, events, forum etc. The question isn't should you. It's more like why would you not want to? This way all your data can be related easily.
2. Easier than you might think. They are both Microsoft products after all.
3. Connection string for each database. Again, see #1. Putting it all in one database and upsizing to SQL server is the only way to fly if you have the resources available.
@tomic |
SportsBettingAcumen.com |
 |
|
|
Astralis
Senior Member
USA
1218 Posts |
Posted - 29 October 2002 : 18:19:56
|
Thanks atomic.
That sounds reassuring!
"Look at it fly!" - Multiple Migs |
Edited by - Astralis on 29 October 2002 18:20:40 |
|
|
| |
Topic |
|
|
|
Topic Locked
