
How to backup the database structure only?
updated at
Apply OS: Windows, macOS, Linux
Apply Navicat Product: All
Apply Navicat Version No.: All
If you wish to backup the database structure, please follow steps below:
Version 11.2 or below:
- Choose Tools > Data Transfer, and select General tab.
- Under Source, specify Connection, Database/Schema and your preferable objects you wish to backup.
- Under Target, enable Transfer to file or select File option, specify location and name for the SQL File.
- Select Advanced tab and uncheck Create records or Insert records under Record Options.
- Click Start.
- Click Save to save the settings as a profile for scheduling.
Version 12 or above:
- Choose Tools > Data Transfer, and select General tab.
- Under Source, specify Connection, Database/Schema.
- Under Target, select File option, specify location and name for the SQL / script file.
- Select Options tab / button and uncheck Create records or Insert records under Record Options.
- Click Next.
- Select your preferable objects you wish to backup
- Click Start.
- Click Save Profile to save the settings as a profile for scheduling.
Have more questions?
-
Support
-
About Us