Elevate Software Logo

Contacts | Partners | Links





Technical Support

Home > Technical Support > Frequently Asked Questions > View Frequently Asked Question




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>





Related Pages

Option Newsgroups (Web)

Option Newsgroups (News Server)

Option Incident Reports

Option Roadmap

Option Technical Bulletins

Option Technical Articles

Option Product Manuals

Option Product Roadmaps






This web page was last updated on
Monday, October 27, 2008 at 03:27 PM

Valid HTML 4.01!  Valid CSS!


Privacy Policy

© 2008 Elevate Software, Inc. All Rights Reserved
Questions or comments ? E-mail us at info@elevatesoft.com