How can I convert and ACCESS database to MSSQL database?

[asuknow]

Is there any software/tools to do that?

If I convert an ACCESS database to a MSSQL database,
will that make reading and writing a database faster?
Do I need to modify ASP script a lot to make it
faster? Will most of my ASP for accessing ACCESS database
still work for accessing MSSQL databse converted from
ACCESS?

Thank you for any help!!!

 

[asuknow]

Let me ask one more question:
As far as a middle to large scale online shopping mall
is concened, which of the follwing database is the best?
(i mean the most efficient and fatest)
(1) MSSQL
(2) mySQL
(3) mSQL ( is it for business?)
(4) ACCESS (how many concurrent userd can it accomodate?)

Are there any tools that can make conversions between
any of th two types of databases above?

Thanks for any help!

 

[ToddWW]

I'm not an expert by experience here, so I can only quote you from what I've heard.

Considering websites like Bank of America, Barnes & Noble, and buy.com are using SQL Server 2000, I would say it's safe to assume that you're going to be good there.

See the entire list here.

http://www.microsoft.com/sql/evaluation/casestudies/2000/default.asp

Access is going to run into problems when it gets loaded down with users. I know that from experience in a test environment. I use FoxPro in my App and I know I'm going to need to convert soon. Here's a paragraph from Mastering ASP by A. Russell Jones.. It might shed some light on the Access -vs- SQL Server differences. Actually, it's kinda harsh on Access.

When I mention relational databases, I'm specifically NOT discussing MS Access or any other file-based database. Although you can use Access for practice, it's not suitable for a full-scale Web application with more than a small number of users. It's definitely not suitable for any users if the data is critical. If you were considering using Access for your Web application--don't. In fact, I recommend that you not use it at all, even for practice. Consider using the newer MSDE (Microsoft Data Engine) instead. It supports the same syntax as SQL Server, which means you won't have to change your application when you deploy it for use with SQL Server. MSDE is no more suited for a large-scale or critical Web application than Access, but it is considerably easier to upgrade to SQL Server.

I think that means that you'll have a little work to do converting over to SQL Server from Access, but I don't think it will be too bad. It all depends on how large your current App is. Most of the changes will be in your SQL statements and conventions. All of the rest of your ASP code (VBScript, etc..) should run just fine.

Hope this helps a little.

Happy Converting

ToddWW

 

[Cirrus9]

You can also export the database in a comma, tab or space delimited format and import it.