How do I change the path of a defined database after a database has been moved to a different location ?You would first use the DROP DATABASE statement to drop the existing database, but keep the existing database contents:
DROP DATABASE <DatabaseName> KEEP CONTENTS and then create the database again, but use the new location as the database path:
CREATE DATABASE <DatabaseName> PATH <NewPath> Note
As of ElevateDB 1.06, you can simply use the ALTER DATABASE statement:
ALTER DATABASE <DatabaseName> PATH <NewPath>
| |
|
| |
|