Change Databases

[PointsWell]

Is there a way to change all my prior Configs from one database to another?

For example I am working on a BSV application
I'd like all the Application data to move to Backup
And then I want to delete Application before recreating it with the last config.

I did have a look at the database and tried renaming the DName column in Domain and DomainVersions tables in the BASDB and BASDBTEST databases but there is obviously something else in the database that is not human readable and so it didn't work as hoped.

Does anyone have a faster method than Export, Import of the various versions?

I have both the live and the test database running in separate DB instances.

[ACDC]

A.
1. Dump your DB to a .sql file (The Published version -basdb)
2. Export the application BSV file (The published version representing the above)

These files are all that's needed to relocate to another machine.
----------------------
B.
Recreate your development environment

1. Import your BSV
2. Publish your BSV .
3. Restore your DB by restoring the .sql dump

If you wish to maintain your test DB then repeat process


If part of your question was related to changing the name of the app. Then edit your .sql file using a good text editor to Find and Replace all references to the App name - Then restore the newly edited .sql file into to the newly named/ created and published BSV

I did have a look at the database and tried renaming the DName column in Domain and DomainVersions tables in the BASDB and BASDBTEST

Its not a good idea to tinker with these settings