You can enable logging of the SQL statements generated in SQL Central by selecting "View" > Click Server Messages And Executed SQL (Alternatively you can press Alt+1). For example, if you want to backup a database, but can’t remember how to backup the transaction log only, type dbbackup -? and a list of options will appear.įinally, all utilities run using SQL Central can also be executed via SQL statements from Interactive SQL. If you are more comfortable using the command line instructions, but you find them hard to remember, you can use the -? option, which is supported for all SQL Anywhere 17 utilities. The command line steps are incremental, so there is no need to execute the commands until they are complete. The document proceeds through tasks using SQL Central as the example, but immediately after each step in SQL Central is a corresponding command prompt statement, labeled with the iconĬontinue by adding the file name hello.db. Throughout the document, SQL Central and the command prompt are used to show both ways of completing a given task. This document was created using SQL Anywhere 17., on a Windows 8 computer, but applies to all major and minor builds of SQL Anywhere 17 on all supported operating systems. The purpose of this document is to give new users of SQL Anywhere 17 an understanding of both SQL Central wizards and command line utilities, and the relationships between them. This document describes the most common utilities in SQL Anywhere 17. This WIKI discusses the SQL Central utilities and their command line equivalents.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |