Stellar Log Analyzer for SQL Anywhere
Stellar Log Analyzer for SQL Anywhere
If you only want to save the data of the log file then Log Tables Data save option should be used.
Run Stellar Log Analyzer for SQL Anywhere.
See Select SQL Anywhere Log File, to know how to select SQL Anywhere log file.
See Analyze SQL Anywhere Log File, to know how to analyze SQL Anywhere log file.
After the analysis process is completed, select the table(s) you want to save and click on Save from File ribbon OR select Save option from the Quick Access toolbar to save the Log data file.
There are four different file formats to save Log data file. Choose any one of them from Select section.
SQL Anywhere
CSV
HTML
XLS
From Select transaction to save section, choose the required (Insert, Update or Delete) you want to save in the database by selecting their respective checkbox.
Click Browse to select the path where you want to save the log file and click Ok. (Browse Option is enable for only CSV,HTML,XLS)
You can apply date filters to save the results from a particular time period by selecting Apply date range checkbox. From the Date Range section select the dates between which you want to apply the filter. Click OK.
Note: By default Automatically open destination folder after saving check-box is checked, if you don't want to open the destination folder kindly uncheck the checkbox.
A Save As dialog box appears as shown below:
Open SQL Anywhere application and create a new database file (.db), in which you want to save the data.
From Save As window, Select the version of the newly created database file.
If you want to save the log tables data to a Live Database then select option 3 and provide the name of the Server.
OR
If you want to save the log tables data to a New Database file then select option 4. Click Browse and locate destination of the newly created database file in which data is to be saved.
Give User Name and Password of database file to which data is to be saved.
Note: By default, in SQL Anywhere User Name is "DBA" and Password is "sql".
Click Start to start the saving process.
Selected database file is saved to the specified destination.
A dialoge box will appear as Save complete. Click Ok.