SQL Anywhere Studio 9 Developer's Guide

SQL Anywhere Studio 9 Developer's Guide

4.11 - 1251 ratings - Source

Companion CD includes SQL Anywhere Studio 9 Developer Edition (for Windows), all the code from the examples and full BNF from the book in HTML format!SQL Anywhere Studio 9 Developer's Guide describes in detail how to administer and program SQL Anywhere, the leading relational database for mobile, distributed, and embedded applications. This book focuses on the various tasks performed during the life cycle of a typical database, such as creating tables and other schema objects, and inserting, selecting, updating, and deleting data. Additional topics include packaging SQL code into procedures, triggers, and events; distributing data across multiple databases using MobiLink; protecting the database from disaster; and tuning for performance.Learn how to create and normalize tables with various data types and constraints; insert and manage data; retrieve data with the SELECT statement; synchronize data with MobiLink; protect your data through the use of logging, backups, and validation; optimize your database using the SQL Anywhere performance tuning tools: request-level logging, Index Consultant, Execution Profiler, and Graphical Plan.aquot;%ASANY9%\win32\dbeng9.exeaquot; -x none volume.db Step 2: Run the SQL Anywhere dbunload.exe program to create an unloaded data file in text format for each table, as well as a reload.sql command file to be used later to load that data intoanbsp;...

Title:SQL Anywhere Studio 9 Developer's Guide
Author:Breck Carter
Publisher:Wordware Publishing, Inc. - 2004


You Must CONTINUE and create a free account to access unlimited downloads & streaming