Using drag & drop database management tasks

DatAdmin supports a big variety of drag & drop operations, you can use it for different database administration tasks. This overview shows most common use cases.

You can use drag & drop for:

• copy database
• backup and restore database
• copy table(s)
• copy table data (with ability to choose column mapping)
• copy and move files in connection tree

All described drag & drop operations can be done in connection tree or in summary window (of course also between connection tree and summary view)

Database tasks

• Copy database to another database server - drag & drop database to target server
• Copy database structure and data - drag & drop source database to target database
• Synchronize database structure - drag & drop source database to target database
• Synchronize data - drag & drop source database to target database
• Backup database - drag & drop database to folder in connection tree (eg. to root named "Data"), select "Create data archive"
• Save database model - reverse engineering - drag & drop database to folder in connection tree (eg. to root named "Data"), select "Save structure"
• Restore database - drag & drop data archive (file with DBK extension) to database node

Table tasks

• Copy table to another database - drag & drop trable to target database (you can choose, whether to copy also data or only structure)
• Copy table data - drag & drop source table to target table (you will be able to choose column mapping)