weblike Hi, I have an old BSV, before we were able to choose separate DB for live&testing. Is there a way to change the DB live or test for an existing BSV? thx,
ACDC I don't think there is an option for this, I would do the following Export the BSV Backup the database Re create the application with the correct DB settings, run test and publish . Restoring data to the newly named DB Dump the old basdb objects to FIlename .sql file (before doing the dump remove the Objects associated to the old BSV like Domain Versions, Domains etc - we don't want to restore this in the new setup as it is already there with the new publish process). Using a good text editor, edit the dumped .sql file and use FIND and REPLACE all reference to the old DB and Object Names to the newly created DB and object names ( Before doing this make sure you study the newly created DB layout and compare it to the old DB names layout. Isolate the parts that need to be renamed and use FIND and REPLACE to make the change) Example FIND 'CRM_' and REPLACE WITH '' ..(leave it blank) Restore newly edited .sql dump and it should be fine 9
