Access VS SQL

Results 1 to 2 of 2

Thread: Access VS SQL

  1. #1
    Join Date
    Dec 1969

    Default Access VS SQL

    Hello,<BR><BR> I am building one aplication that uses some DB. I wold like to know if it is better to have difrent DB for diferent areas of the site or if it is better to have all tables in the same DB. <BR><BR> The other thing is that i am using access DB; I am thinking on migrating the db to a SQL server. What sould i be concerned about and what are the main diferences in the ASP code? What will i have to change to transform the access DB into SQL DB and what are the incompatibilities betwen the two formats.<BR><BR>Best regards, Miguel Vaz

  2. #2
    Lobster Boy Guest

    Default RE: Access VS SQL

    It is "better" to do whatever makes more sense for your application. Usually one database is easier to maintain than several (one to backup, one to restore).<BR><BR>The only change you should have to make in your ASP code is the DSN (assuming you are using ADO).

Posting Permissions

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