I will want to know more about SQL database. Total number of entries permitted to each SQL table. It is possible to transfer SQL database to one server to another server (web hosting company). It is possible to reduce size of database (deleting some of pending articles). Please good replay.
The limits of the SQL database depend on two things. The database that you are using (almost all databases are SQL databases) is the first. The second is the hardware that you have. Some databases (like Access used to be - still is?) have built in limitations. Oracle, MS SQL, MySQL, DB2, etc... do not have many built in limitations. The limitations come from the hardware and/or the set up of the table. Hardware limitations are not set in stone. It really depends on the type of actions you take on the table. If you are running full text searches on poorly indexed tables, you will hit limitations well before you would if you were running simple, single table result set returns. Set up limitations come from not planning ahead. For example, if you use an autogenerated primary key with an int format, then you will be limited in the number of records by the the limits of an int (for that database) in that table. A database can be transfered to different servers, and even to other database programs. There can be issues some times. Examples of issues: some databases have unique data types that must be converted before transferring to a different database software; in the past there have been issues where numerical data types allowed for numbers that would be out of range in the same data type of a different database program; if you use stored procedures, each of the big databases has a few functions that are unique to them (or the syntax is slightly different). Anything that is written in straight SQL is relatively easy to transfer. Things that are written in the SQL subset for that particular database (Transact-SQL for MS SQL, or PL for Oracle) will require some work before moving over. Generally though, the table structure and data is fairly easy to move around. If you are moving between machines, but the database program is the same (including version) it should be very easy to move the database. Database size can be reduced by removing old entries. Usually there is also a set of logs that can be purged every so often. Picking appropriate data types is also important. Most data types set aside a specific amount of space for the data to be entered in. By setting the size or data type properly can save a lot of space (for example, a char(255) field is way too big for last name). Were you looking for information on a specific database?