Novosoft Office Backup has a special functionality for easy backup of popular databases which support ODBC driver, including My SQL, MS SQL, DB2, MS Access, PostgreSQL, FoxPro, Oracle, Interbase etc.
Note: Database Backup feature is available only in Novosoft Office Backup Professional version.
The 'Select Data Source' dialog will appear. In the Select Data Source dialog, select one of the existing data sources or create a new data source to get access to the files of specific database.
You can select File Data Source or Machine Data Source by clicking respective tabs. File Data Source is stored as a regular file in your local computer. Machine Data Source is stored as the system source in the System Registry.
In the File Data Source tab, click the arrow in the 'Look in' field to look for the file data sources created earlier on your computer or remote computer. If there are no data sources for your database, create a new one. See how to create a new file data source in File Data Source.
In the Machine Data Source tab simply select an appropriate data source from the list or create a new machine data source. See how to create a new data source in Machine Data Source.
Note: Novosoft Office Backup can only back up database tables. It cannot back up store procedures, views, functions, triggers etc from the database.
When restoring database tables to a new database, it is recommended to use a database of the same type and version, or with an identical structure. Otherwise, the following problems may occur: