Many other SQL Anywhere 17 tools are located in the C:\Program Files\SQL Anywhere 17\Bin64 folder. For more information on any of these and other tools, consult the SQL Anywhere documentation. The previous tools are very common and have been described throughout this document.
Below is a table that directly maps some of the tools in SQL Central to the command line utilities. Remember that every SQL Anywhere command line utility supports the -? option, which can help you determine which options to add to a command. SQL Central is easier to follow along step-by-step, but the command line may be faster if you already know which options you want to use. Refer to the Following Wiki Pagesīackup Database (dbbackup) Connecting to and Disconnecting from a SQL Anywhere Database (dbsrv17, dbeng17 and dbstop) Create a Service (dbsvc) Create Database (dbinit) Erase Database (dberase) Transaction Log File (dbtran) Unload Database (dbunload) Validate Database (dbvalid) Conclusionīoth SQL Central and the command line achieve the same end results. The SQL statements appear on the Database tab in the Server Messages And Executed SQL pane at the bottom of the SQL Central window. 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 kommentar(er)
