I’ll appreciate any help you can gi 1

[mrkyn]

I’ll appreciate any help you can give me. What is the best and cheapest way to manage database of a small online business (SQL Server, Oracle, which version)? The database should contain just some information about visitors of the site. The site is written in ASP.NET. I haven’t chosen a host for the site.
Thanks.

 

[Elminster]

If you don't have a big volume of data to put in the DB, the cheapest is Access.

 

[Zarcom]

I would go with MSDE rather than Access any day. MSDE uses the SQL Server engine except it is FREE. You just don't get the UI that SQL Server has and it is slightly crippled. Check out MS site for more info. That'l do donkey, that'l do
Mark
If you are unsure of forum etiquette check here faq796-2540

 

[johnfrederick]

1. In the ASP days, I liked Access because I could teach a client (with a workstation Access installation) to open the web site using FrontPage, double click the Access mdb to open it, and copy and paste the new records into a local mdb. No need for a complicated procedure to get the data to and from. An alternative is to FTP the mdbs back and forth. Can't do that with SQL server because of the security. You have to get involved with logic on the server.

2. You can get all the SQL Server 2000 UI machinery for MSDE 2 by installing an evaluation copy without the database engine. Choose SQLServer, then "SQL server and Client Tools. Then after the license agreement, select Client Tools Only. You can also do Analysis Services and the SP2 will install (won't install on full evaluation copy). This was in the readme bumf that came with .NET, but one of our local gurus, Steve Forte told me about it.

 

[Elminster]

I guys, I was wondering if MSDE can handel as much data that SQL Server? Is security the same? Does it have some kind of UI ... or is it all command line? What about performance, is it as quick as SQL Server? Is it as relyable?

Frankly, I didn't know that it existed ... that's why I recommanded Access. I have a project to build, and whas about to buy SQL Server, but I'll try this first.

 

[Zarcom]

<quote> You just don't get the UI that SQL Server has and it is slightly crippled. Check out MS site for more info</quote>

It can't handle as many concurrent users as SQL but the basic engine behind the db is the same. Like I said it has simply been crippled so that people will upgrade to SQL Server. Which is very very easy since they use the exact same engine. (Read NO code changes)

This may help

http://www.microsoft.com/sql/howtobuy/msdeuse.asp

That'l do donkey, that'l do
Mark
If you are unsure of forum etiquette check here faq796-2540

 

[Elminster]

Txs a lot Mark. it's been helpful.

 

[Zarcom]

welcome That'l do donkey, that'l do
Mark
If you are unsure of forum etiquette check here faq796-2540