Knowledge Base
Document information
| Document ID: | 5338 |
|---|
| Subject: | Automatically Saving Sessions in WinSQL |
|---|
| Creation date: | 1/15/20 10:41 AM |
|---|
| Last modified on: | 1/15/20 10:50 AM |
|---|
Automatically Saving Sessions in WinSQL
WinSQL will remember the values for your existing session in between restarts when Auto-Save sessions is enabled. WinSQL performs following tasks in the background:
- Save queries as well as results of every query page and connection to disk before exiting. Connection data is also saved.
- Saved data is automatically loaded next time you open WinSQL.
- Database connections are automatically established
Limitations Multiple Instances
The saved data for a session is stored in the
DataFolder. If you have multiple instances of WinSQL loaded simultaneously, it will only remember the sessions from the instance that was closed last.
Using Command-Line Arguments
Prior to v14, command-line arguments are not used when the Auto-Save session is enabled.
Starting from v14, WinSQL automatically disables Auto-Save temporarily when a file is opened using command-line arguments. Consider the following example:
WinSQL.exe C:\MyScripts\Sample1.sql -uMyUserId -pMyPassword -dMyServerDSN
In the above example, a user wants to create a shortcut on their Desktop so they can easily open a script file.
Prior to v14, you had to disable Auto-Save sessions in order for the above example to work. Starting from v14, WinSQL will automatically disable Auto-Save sessions temporarily for this particular instance. Keep in mind that WinSQL will NOT save the session when it is terminated.
Add a comment to this document
Do you have a helpful tip related to this document that you'd like to share
with other users?
Important: This area is reserved for useful tips. Therefore, do not post any questions here. Instead, use our
public forums to post questions.
