Which database to use?

Discussion in 'Databases' started by casefiler, Aug 25, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. casefiler

    casefiler

    I have successfully developed ASP apps using a MS Access database on DiscountASP.net. Now I need to ramp up and I understand Access may be too slow and limited. My question is this:

    I see that you support several versions of SQL. I have a little experience with MySQL 5.0, but what are the relative merits of using one of the other versions? What apps will I need for offline development and testing? I use Dreamweaver MX as my principal development tool with IIS form my local testing server.

    Would appreciate any advice or suggestions.

    -Michael
     
    casefiler, Aug 25, 2006
    #1
  2. casefiler

    casefiler

    Thanks, that's the answer I was looking for. Don't need to learn to speak French if I'm just passing through en route to Germany.


    I get the impression from reading the other poststhat developers aretypically using SQL Express for local development then publishingto SQL '05 on your servers?Arethere any technicalproblems with that, and does that help or hurt the "learning curve"?


    Again, thanks for the help. Support here is awesome compared to my prior hosting companies.


    -M
     
    casefiler, Aug 26, 2006
    #2
  3. Bruce

    Bruce DiscountASP.NET Staff

    SQL 2005 express uses the same database engine as SQL 2005. The transition should be rather smooth.

    However, if you can shell out a little bit of money, i recommend you get SQL 2005 developer edition. It cost less than $100 US.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Aug 26, 2006
    #3
  4. Bruce

    Bruce DiscountASP.NET Staff

    I would recommend going to SQL 2005 rather than MySQL.

    You will run into a little bit of learning curve but if you are working with MS technologies, you should get comfortable w/ SQL 2k5 sooner or later.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Aug 26, 2006
    #4
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page