Database Information

Results 1 to 2 of 2

Thread: Database Information

  1. #1
    Join Date
    Dec 1969

    Default Database Information

    Hi Guys,<BR><BR>Mostly when I am building sites I use access databases, I know that this sort of database is sufficient for not very heavy sites. At the moment i&#039;m working on some sites that will be quite busy and they do have a heavy database presence.<BR><BR>Can anyone advise me on the best databases that can be used on such heavy sites and also what are the main differences/advantages from just the usual access databases that make them better.<BR><BR>Also how easy would it be to upgrade a site that uses an access database to be able to use a better database, would there be much re-written code?<BR><BR>Any help would be greatly appreciated.<BR><BR>Jarvis

  2. #2
    Join Date
    Dec 1969

    Default RE: Database Information

    Use either SQL Server or Oracle (considerably more complicated and costly than SQL Server).<BR><BR>You can import your Access tables in SQL Server. But the queries (in Access, not ASP) have to imported manually, and usually require a good under of stored procedures. SQL command in ASP don&#039;t need to be changes much. In SQL Server, you do not need to use the # for inserting dates, just enclose with single quotes.<BR><BR>Get a good book on SQL Server like Professional SQL Server Programming (WROX).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts