WEB HOSTING - SQL - ACCESS ONLINE DATABASE SYSTEMS

WELCOME TO AeroHOST - a premium web hosting service featuring SQL or Access online database systems

SQL server hosting online: Access vs SQL.

Put your data on-line with Active Server pages (ASP and ASPX) : Start with Access and migrate easily to SQL server when website traffic demands increase:

We have created a simple Microsoft Access database demonstration using SQL commands that will query an on line MS Access database consisting of 10,000 non-indexed records. The field values are populated simply with numbers from 1 to 10,000 so that you can deliberately search for records at the beginning, middle or end of the database in order to test the speed.

Please click HERE to try the demo out for yourself.

HOME PAGE

CORE TECHNOLOGIES:

LOAD BALANCED SERVERS

Statistics Demo

All our website hosting plans accommodate on-line Access database systems. Microsoft Access will easily handle most requirements, but if you need a truly powerful system for large traffic demands, we also offer MS SQL server. Access users can easily migrate to SQL when the site traffic warrants it. Please visit our site home page for further information ....

If you have any questions about how to set up your database, please contact us

The Microsoft Access 97/2000 is a full-featured multiuser relational database management system that designed for the Microsoft Windows operating systems (such as Windows 9x, Windows 2000 and up). Access 97/2000 is extremely visually oriented and easy to use. It makes extensive use of drag-and-drop and visual design for queries, forms, and reports. Access 97/2000 comes with an integrated development environment (IDE), including incremental compilation, a fully interactive visual debugger, breakpoints, and single step-through. These capabilities combine to make Microsoft Access an extremely powerful platform for developing client-server database solutions.

The maximum database size is 1 GB, but your database can include linked tables in other files, and its total size is limited only by available storage capacity. Number of characters in a Memo field can be up to 65,535 characters when entering data through the user interface or can be up to 1 GB when entering data programmatically.

Here are the general Access 97/2000 characteristics:

Access Object	Maximum sizes/numbers
No. of concurrent users	255
No. of fields in a table	255
Database size	1 GB
No. of characters in an object name	64
No. of characters in a password	14
No. of characters in a user name or group name	20
No. of characters in a table name	64
No. of characters in a field name	64
No. of characters in a Text field	255
No. of characters in a Memo field	65,535 / 1 GB

SQL Server 7.0/2000

SQL Server 2000 Enterprise Edition on the Windows 2000 DataCenter can support up to 32 CPU and up to 64GB physical memory (RAM) on a computer!

How Fast Is Fast? SQL Server 2000 can handle 709,220 transactions per minute! SQL Server 2000 has further established its position as the fastest database in the world. With a performance rating of 709,220 transactions per minute (tpmC) and price/tpmC of $14.96 US, a 32-node Compaq ProLiant DL760-900-256P system exceeded the previous record, which was also held by SQL Server 2000.

Another benchmark test demonstrated support for 25,200 simulated concurrent users and performed CRM transactions at the rate of 2,024 business processes per minute. These results were achieved on a 24-processor Unisys ES7000 database server and yielded average response times between one and two seconds.

How do I convert an .MDB to SQL Server?

For Access 97: The Access Upsizing Wizard Free download:

http://www.microsoft.com/accessdev/prodinfo/aut97dat.htm

It preserves database structure including data, indexes, defaults, and so on, and automatically converts Access validation rules and defaults to the appropriate SQL Server equivalents. It also maintains table relationships and referential integrity after upsizing.

For Access 2000: (Upgrading to an .ADP file) The upsizing wizard is built in to the Access runtime. You can choose to create an .MDB with SQL Server tables linked, or to an .ADP file. Provides all the functionality of the Access 97 upsizing wizard.

These are the general SQL Server 97/2000 characteristics:

SQL Object	Maximum sizes/numbers
Connections per client	Maximum value of configured connections
Batch size	65,536 * Network Packet Size
Bytes per short string column	8,000
Bytes per text, ntext, or image column	2 GB-2
Bytes per index	900
Bytes per primary key	900
Bytes per foreign key	900
Bytes per row	8,060
Clustered indexes per table	1
Bytes in source text of a stored procedure	Lesser of batch size or 250 MB
Columns per index	16
Columns per primary key	16
Columns per foreign key	16
Columns per base table	1,024
Columns per INSERT statement	1,024
Columns per SELECT statement	4,096
Database size	1,048,516 TB
Databases per instance of SQL Server	32,767
Filegroups per database	256
File size (data)	32 TB
Files per database	32,767
Identifier length (in characters)	128
Nested stored procedure levels	32
Locks per connection	Max. locks per server
Nested subqueries	32
Nested trigger levels	32
Objects in a database	2,147,483,647
Nonclustered indexes per table	249
Parameters per stored procedure	1,024
REFERENCES per table	253
Rows per table	Limited by available storage
Tables per database	Limited by number of objects in a database
Tables per SELECT statement	256
UNIQUE indexes or constraints per table	249 nonclustered and 1 clustered
Triggers per table	Limited by number of objects in a database