Moving from Access to ?

Results 1 to 3 of 3

Thread: Moving from Access to ?

  1. #1
    Join Date
    Dec 1969

    Default Moving from Access to ?

    Hi<BR>We have been using Access succesfully for 3 years now. One application gets busy times around winter. We think that the Access DB is causing problems in these busy times. We would like to move to a more stable, more reliable, able to handle more connections DB. Can anyone suggest a DB type that I can move my access DB to that will work easily with ASP. Are their any tools that will port an Access DB to this new Db type?<BR>Thanks for any help. <BR>Jamie

  2. #2
    Join Date
    Dec 1969

    Default RE: Moving from Access to ?

    SQL Server (another microsoft product) which is the next step up from Access...<BR><BR>Access ports over to SQL Server very easily...<BR>Look as some of the tools found within Access, the tools are there to upsize...<BR><BR>And you can do it with very very little changes to your existing asp code...<BR><BR>Worth reading up on.<BR><BR>

  3. #3
    Join Date
    Dec 1969

    Default And to be fair...

    ...converting to MySQL isn&#039;t *that* hard.<BR><BR>The biggest problem with changing DB&#039;s isn&#039;t the data, it&#039;s the SQL queries. Every DB has it&#039;s own unique "flavor" of SQL. Things that are easy to do in Access are tough to do in SQL Server and/or MySQL (and vice versa!). The more "vanilla" your SQL queries are, the easier the port will be. The more you rely upon functions unique to Access (that is, the VBA functions, especially), the harder it will be.<BR><BR>If you showed us a few of your more exotic SQL queries that you use with Access, it would be easier to judge.<BR><BR>Perhaps the biggest change you will encounter is that neither SQL Server nor MySQL have a boolean data type. That&#039;s the data type that Access uses for Yes/No and True/False fields. You end up having to use a bit or tinyint numeric field, instead. And that can mean some subtle changes that you might not catch first time out.<BR><BR>How many tables are you talking about, all told? More than 20 or 30?

Posting Permissions

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