MS SQL 2000 developer edition?

I'm only familiar with Access

[dickbaker]

I'm comtemplating starting my own database-driven website, and I've read that Access is not a good RDMS for large sites that have a lot of re-writes to the database.

Bear with me here, because I'm primarily a Mac user. ;)

Once the database is created, it will be updated right from the website. I've done this a lot with Access databases.

My question is: does the developer edition allow you to create the database? The product information provided on Microsoft's website is pretty skimpy.

Thanks for any replies.

[sun818]

> does the developer edition allow you to create the database?

Yes, but only for your workstation:
[microsoft.com...]

[edited by: sun818 at 8:19 pm (utc) on Nov. 23, 2003]

[wardbekker]

The developer edition is pretty much the same as the enterprise version. There are some limits in performance. I'm using it a lot but never noticed any problems when developing.

[dickbaker]

Hmmm, there seems to be a conflict of opinion.

I'll be using a hosting company that already has the MS SQL server software installed. I just need to create the databases and upload them.

Does this help clarify my question?

Thanks in advance.

Dick

[sun818]

Developer edition is fine then. Your web host has the Enterprise Edition license. You develop on your workstation like the license states, then migrate to the web host production database using the DTS Export tool.

[plumsauce]

never been able to wrap my brain around DTS

so the alternative i use is sp_detach and sp_attach
to ship db's around.

[Small Website Guy]

The Developer edition is all you need. You'd be wasting money buying the full edition.