In Informix, is it possible to copy a database within the same server/host?
1
vote
0
answers
223
views
Assuming a user has sufficient privileges on the server, is it possible to copy a database in its entirety within the same server/host, using SQL only (i.e. without having shell access to the Linux server running Informix)? Not just tables and views but also stored procedures?
On postgresql, it would be something like
CREATE DATABASE copy_db WITH TEMPLATE original_db;
I ask because I am interested in creating a 'master' copy of a database that can be replicated on demand when running integration tests.
I am on Informix Dynamic Server 14.
Asked by user3243135
(199 rep)
Feb 26, 2023, 01:35 AM