Hi



I've just completed my webpage page for work using ASP and Microsoft 

Access as the Database engine.

I found out that Microsoft Access is really bad for high traffic browsing.



If I were to switch to SQL server or Oracle, how much of the ASP coding 

would I have to change if any?

In terms of web browsing efficiency and also ease of building the database 

over again, which would you recommend - SQL serveer or Oracle?



I don't have to build my database from scratch again do I?  Can I import 

stuff from Access to Oracle or SQL Server?



Thanks for your input

Kien Vinh

You can import an access database right into SQL.  Create a new SQL database

with the same name as your access database.  You can then "all tasks" ->

"import data" and the source would be "Microsoft Access".  This should keep

all of your tables the same so you shouldn't have to change any of your

scripts.  You will, however, need to change your connection method/driver.



-Eli



-----Original Message-----

From: Kien Vinh Duong [mailto:kienvinh.duong@u...]

Sent: Thursday, July 19, 2001 8:53 AM

To: ASP Database Setup

Subject: [asp_database_setup] HELP =o Pros and Cons of various Database

systems





Hi



I've just completed my webpage page for work using ASP and Microsoft 

Access as the Database engine.

I found out that Microsoft Access is really bad for high traffic browsing.



If I were to switch to SQL server or Oracle, how much of the ASP coding 

would I have to change if any?

In terms of web browsing efficiency and also ease of building the database 

over again, which would you recommend - SQL serveer or Oracle?



I don't have to build my database from scratch again do I?  Can I import 

stuff from Access to Oracle or SQL Server?



Thanks for your input

Kien Vinh

Hi Kien!



I have also experience the same problem as you. I used MS Access as my 

database engine. However, I changed it to Oracle.

The differences between MS SQL Server and Oracle is that SQL Server are for 

smaller business, if you are working for a big company or have lots of data 

entry. I recommend you using Oracle, because it's common use for enterprise 

business wise. There are also others database engine that you can use such 

as sysbase and others.

Oracle and Access for differently, what did you use to connect into the 

database? Active Data Object? or something else...

anyways, that's about it good luck!!



Vicky



>From: "Kien Vinh Duong" <kienvinh.duong@u...>

>Reply-To: "ASP Database Setup" <asp_database_setup@p...>

>To: "ASP Database Setup" <asp_database_setup@p...>

>Subject: [asp_database_setup] HELP =o  Pros and Cons of various Database 

>systems

>Date: Thu, 19 Jul 2001 15:52:53

>

>Hi

>

>I've just completed my webpage page for work using ASP and Microsoft

>Access as the Database engine.

>I found out that Microsoft Access is really bad for high traffic browsing.

>

>If I were to switch to SQL server or Oracle, how much of the ASP coding

>would I have to change if any?

>In terms of web browsing efficiency and also ease of building the database

>over again, which would you recommend - SQL serveer or Oracle?

>

>I don't have to build my database from scratch again do I?  Can I import

>stuff from Access to Oracle or SQL Server?

>

>Thanks for your input

>Kien Vinh

Thank you very much for the reply Eli =)



When I import the Access file to SQL, what is imported exactly? Everything ,ie 

tables and FORMS or just tables.



If only tables are imported, how relatively easy or difficult is it to make 

forms in SQL compared to Access?



Thanks again

Kien Vinh



Quoting Eli Schilling <eschilli@t...>:



> You can import an access database right into SQL.  Create a new SQL

> database

> with the same name as your access database.  You can then "all tasks"

> ->

> "import data" and the source would be "Microsoft Access".  This should

> keep

> all of your tables the same so you shouldn't have to change any of

> your

> scripts.  You will, however, need to change your connection

> method/driver.

> 

> -Eli

> 

> -----Original Message-----

> From: Kien Vinh Duong [mailto:kienvinh.duong@u...]

> Sent: Thursday, July 19, 2001 8:53 AM

> To: ASP Database Setup

> Subject: [asp_database_setup] HELP =o Pros and Cons of various

> Database

> systems

> 

> 

> Hi

> 

> I've just completed my webpage page for work using ASP and Microsoft 

> Access as the Database engine.

> I found out that Microsoft Access is really bad for high traffic

> browsing.

> 

> If I were to switch to SQL server or Oracle, how much of the ASP coding

> 

> would I have to change if any?

> In terms of web browsing efficiency and also ease of building the

> database 

> over again, which would you recommend - SQL serveer or Oracle?

> 

> I don't have to build my database from scratch again do I?  Can I import

> 

> stuff from Access to Oracle or SQL Server?

> 

> Thanks for your input

> Kien Vinh

>

Hi...thanks for your input



I'm using ADO I think...and you?

so how much of the ASP coding did you have to change besides the connection 

string.

How about all your forms and tables from Access, where you able to import / 

reues them in Oracle?

How long did it take you to "switch" over to oracle, the reason i'm asking is 

that i dont' have a whole lot of time and i'm not sure how likely that the site 

that i'm working on will ever exceed..say 20+ people.



Kien



Quoting Fione Ho <fione0212@h...>:



> Hi Kien!

> 

> I have also experience the same problem as you. I used MS Access as my

> 

> database engine. However, I changed it to Oracle.

> The differences between MS SQL Server and Oracle is that SQL Server are

> for 

> smaller business, if you are working for a big company or have lots of

> data 

> entry. I recommend you using Oracle, because it's common use for

> enterprise 

> business wise. There are also others database engine that you can use

> such 

> as sysbase and others.

> Oracle and Access for differently, what did you use to connect into the

> 

> database? Active Data Object? or something else...

> anyways, that's about it good luck!!

> 

> Vicky

> 

> >From: "Kien Vinh Duong" <kienvinh.duong@u...>

> >Reply-To: "ASP Database Setup" <asp_database_setup@p...>

> >To: "ASP Database Setup" <asp_database_setup@p...>

> >Subject: [asp_database_setup] HELP =o  Pros and Cons of various

> Database 

> >systems

> >Date: Thu, 19 Jul 2001 15:52:53

> >

> >Hi

> >

> >I've just completed my webpage page for work using ASP and Microsoft

> >Access as the Database engine.

> >I found out that Microsoft Access is really bad for high traffic

> browsing.

> >

> >If I were to switch to SQL server or Oracle, how much of the ASP

> coding

> >would I have to change if any?

> >In terms of web browsing efficiency and also ease of building the

> database

> >over again, which would you recommend - SQL serveer or Oracle?

> >

> >I don't have to build my database from scratch again do I?  Can I

> import

> >stuff from Access to Oracle or SQL Server?

> >

> >Thanks for your input

> >Kien Vinh