1. First page
  2. Documentation
  3. EBA tools
  4. SQLBrowser

SQLBrowser

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; 

Articles

How can we help?