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
Joined: 24 Jul 2005 Posts: 25 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.
Joined: 24 Jul 2005 Posts: 25 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 Canon
Yesterday - The music of the Beatles
http://yesterday.uk.com jmc@yesterday.uk.com
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
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Your host: Allan Gardyne. Earning a good living from affiliate
programs since 1998.
FAQ
Search
Memberlist
Usergroups
Register
Profile
Private Messages
Log in
