More Information about SQL Database

articles2u · 03-07-2008, 09:01 PM

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.

Peter · 03-08-2008, 02:24 AM

Yes you can transfer databases to other hosts as long as they use the same database engine (ie mysql, mssql etc).

If you are using phpmyadmin to backup your database you in the export area you can choose to download it compressed which should reduce the download size dramatically.

Regarding whether the actual database could be made smaller really depends on your content in the database and what you no longer need.

The maximum amount of data that you can have in a table depend on a few things such as:-

Th processing power and ram available on the server
The storage space on the server
The field type used for your index field

monaco · 03-08-2008, 01:33 PM

All database servers have backup/restore functionality. But yes, they have to be the same with some exceptions. MySQL for instance can export it's backups at MSSQL or ORACLE compatible SQL.

The max amount of data also depends on licensing in some cases. MSSQL and ORACLE have space limitations (in the GB range, granted) unless you buy the most expensive versions which support clustering and SAN's and all that fun stuff.

Peter · 03-08-2008, 01:46 PM

Quote:

Originally Posted by monaco

All database servers have backup/restore functionality. But yes, they have to be the same with some exceptions. MySQL for instance can export it's backups at MSSQL or ORACLE compatible SQL.

The problem isnt just the storage of the data it is also the SQL used to retrieve it.

If you transfer to another engine, even if you change for example to the native mssql mysql functions it may still not work as you may for example be using functions within the sql that act differently in another engine.

monaco · 03-09-2008, 08:40 PM

Quote:

Originally Posted by peter@flexiwebhost

The problem isnt just the storage of the data it is also the SQL used to retrieve it.

If you transfer to another engine, even if you change for example to the native mssql mysql functions it may still not work as you may for example be using functions within the sql that act differently in another engine.

Good point. I didn't think about stored procedures and functions in that one.

articles2u · 05-22-2008, 06:14 PM

Maximum Size allowed (per database) for uploading database to another server.

seanboy · 05-22-2008, 06:28 PM

Quote:

Originally Posted by articles2u

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.

http://dev.mysql.com/doc/

03-07-2008, 09:01 PM	#1 (permalink)
articles2u NamePros Member Join Date: Nov 2007 Location: Mangalore Posts: 111 0.00 NP$ (Donate)	More Information about SQL Database 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. __________________ Articles2u.com - Source for locating information Kokkada.com - Article Directory

03-08-2008, 02:24 AM	#2 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	Yes you can transfer databases to other hosts as long as they use the same database engine (ie mysql, mssql etc). If you are using phpmyadmin to backup your database you in the export area you can choose to download it compressed which should reduce the download size dramatically. Regarding whether the actual database could be made smaller really depends on your content in the database and what you no longer need. The maximum amount of data that you can have in a table depend on a few things such as:- Th processing power and ram available on the server The storage space on the server The field type used for your index field __________________ Manage your portfolio using my new Domain Portfolio Management script. Securing Your Domain Name From Theft

03-08-2008, 01:33 PM	#3 (permalink)
monaco NamePros Regular Join Date: Jul 2005 Location: Tucson, AZ Posts: 695 314.80 NP$ (Donate)	All database servers have backup/restore functionality. But yes, they have to be the same with some exceptions. MySQL for instance can export it's backups at MSSQL or ORACLE compatible SQL. The max amount of data also depends on licensing in some cases. MSSQL and ORACLE have space limitations (in the GB range, granted) unless you buy the most expensive versions which support clustering and SAN's and all that fun stuff. __________________ My Website \| My Blog

05-22-2008, 06:14 PM	#6 (permalink)
articles2u NamePros Member Join Date: Nov 2007 Location: Mangalore Posts: 111 0.00 NP$ (Donate)	Maximum Size allowed (per database) for uploading database to another server. __________________ Articles2u.com - Source for locating information Kokkada.com - Article Directory

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)