|
View previous topic
::
View next topic
|
| Author |
Message |
sarpras
Joined: 03 Apr 2006
Posts: 64
|
Posted: Sun Jan 21, 2007 2:05 am
Post subject: 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 -- Source for locating information
Convert PDF to Word - FREE
Article Directory |
|
| Back to top |
|
 |
Fiatlux
Joined: 24 Jul 2005
Posts: 31
Location: Virginia, USA
|
Posted: Wed Jan 24, 2007 2:02 am
Post subject: More Information about SQL Database.
|
|
|
Structured Query Language (SQL) was last revised in 2006 as ISO/IEC 9075-14-2006. SQL can be used to create, retrieve, update, and delete data from relational database management systems (DBMS). Note that "storage" is missing from the list of SQL capabilities so it becomes obvious that SQL provides an interface to DBMS.
SQL can provide cross-platform portability of applications code but it does not render portable databases. If you are going to develop for one platform and need to keep your options open to move the database to another system I recommend that you find a backup site that is running the same operating system and SQL version that your application is developed for.
Jason _________________ Jason
http://canon.org
Canon Owners Exchange |
|
| Back to top |
|
 |
Onix
Joined: 07 Feb 2007
Posts: 23
Location: Canada
|
|
| Back to top |
|
 |
Fiatlux
Joined: 24 Jul 2005
Posts: 31
Location: Virginia, USA
|
Posted: Thu Feb 15, 2007 1:57 am
Post subject: Information about SQL Database
|
|
|
Not really. A Db dump from Sybase SQL Version x running on a 64-bit big-endian Sun Sparc isn't going to import to a Sybase SQL Version x-1 running on a 32-bit little-endian 32-bit Dell running Linux. And remember, this is a single-vendor (Sybase SQL) incompatibility example. When you are working with multi-vendor SQL systems (e.g., Oracle, Ingress, Access, mySQL, etc.) with different versions running on different computer architectures it is anything but easy. This isn't even considering issues like cross-database referential integrity constraints.
Jason
Onix
PostPosted: Wed Feb 14, 2007 11:34 pm Post subject:
You can easily transfer your Db after making a dump of it. _________________ Jason
http://canon.org
Canon Owners Exchange |
|
| Back to top |
|
 |
Brooke
Joined: 22 Feb 2007
Posts: 19
|
Posted: Mon Feb 26, 2007 4:50 pm
Post subject:
|
|
|
| you should ask your future hosting about their version of sql and wether they can help you with its restoration, but if the datbase is small you can simly do this via web tool phpMyAdmin |
|
| Back to top |
|
 |
| View previous topic :: View next topic |
|