The e-magazine for KNX home & building control

Dr KNX: Opening the ETS4 Database


Dear Dr KNX, I'm using another computer and can no longer open my ETS4 database. Can you advise?
Dear Dr KNX, I’m using another computer and can no longer open my ETS4 database. Can you advise?

Dear KNXer,

KNX Association chose the Microsoft SQL Server as the database engine for ETS4 because this meant that they did not need to develop a proprietary database engine from scratch. There are, however, some consequences of this approach, such as not being able to just move ETS4 database files, not even on the same computer! In such cases, you need to create a backup first and then restore this backup file from the new location.

In the images below you can see where in ETS4 you can deal with databases and backups, and for more detail, consult the ETS4 help module.

KNX database 1

KNX database 2


It is a common recommendation to make backups of any data regularly, so this certainly also counts for ETS databases (projects). Moreover, it is also worth making backup restore checks for ETS4 regularly, because even the ETS4 backup files could get corrupted somehow (due to no fault of its own).

In other words, as any professional working with data within an IT environment, you need a systematic approach to backing up in order to prevent loss of data and hence loss of time and money. It might take a little extra time, but it is your insurance and could save you a big headache in the long-run. As they say, it’s better to be safe than sorry.

I hope that helps, but if you have any questions about this, or any other technical issue, please use the ‘Leave a reply’ option below this article, or send me an email at, and I will do my best to answer you.

Yours truly

You are welcome to comment on this article. See below.

Share on facebook
Share on twitter
Share on linkedin


Products of the month

KNX Switch Actuators Upgrade

KNX Switch Actuators Upgrade
The new ABB ETS App Version 1.1 has a pack of new features empowering the switch actuator range further ...

thePixa Optical Presence Detector

thePixa Optical Presence Detector
Theben's thePixa KNX optical presence detector detects how many people are in a room and where exactly they are ...

Conventional becomes smart

Conventional becomes smart
No dirt, no noise, no bus line – the classic electrical installation is sufficient: the new JUNG KNX RF push-buttons ...

AVE’s KNX room controller

AVE’s KNX room controller
Ideal for home and hotel, AVE Room Controller is a high-design solution with OLED display and touch controls, which ...