SQL Browser is part of the EBA Tools package. With this tool we can perform basic tasks on the database – e.g. view individual tables, fix records, delete, backup entire EBA DMS database, restore backup, etc.
Default program location is: C:\Program Files\EBA\bin\sqlbrowser.exe. If you can’t find the exceutable there check if you’ve ticked option EBA Tools while installing EBA DMS Client.
WARNING: If you are using a SQL user with execute privileges to connect to the database, then be careful – changes may result in altered data or loss of data. We recommend careful execution and perform backup – we recommend backing up the entire SQL database at the SQL level (on the SQL server) and also copying the tables before executing a command.
Easy example of copying an entire table:
SELECT * INTO CustomersBackup2017 FROM Customers;