/build/static/layout/Breadcrumb_cap_w.png

Does anyone know how to export database & import into a SQL program like DBeaver for running some testing SQL

I read somewhere that the k1000 backup Incremental backup is what I would need to download to have an exported copy of the database..


I extracted the file but do not know what all is needed or how to import into a SQL program like DBeaver..


Does anyone have any knowledge??


Thanks

J


0 Comments   [ + ] Show comments

Answers (2)

Posted by: gvega 1 year ago
Senior White Belt
0

The best way to work with the Kace database without hurting or altering it is to use DBeaver or Microsoft Workbench. This allows you to login to the DB and test queries. You are not able to do any updates of any kind which protects the database. A major benefit of this is the ability to save your queries which besides testing for new business rules you can also use to build dashboards in Power Bi or some other dashboard tool. You will need your ip address to the database and your root access password. Once logged in you should see all your tables and can see all the fields by clicking on any table. Here is a link for downloading MS Workbench MySQL :: Download MySQL Workbench 

Posted by: Hobbsy 2 years ago
Red Belt
0

J years ago before I really got into SQL I used to use Access to look at the KACE database, that gave me an option to either look at or copy down all of the data, that may be an option??

You would then have the data and be able to convert, upload or whatever you needed?

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ