Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Moving an Elevate Database
Fri, Oct 23 2009 2:39 PMPermanent Link

"Daniel Kram"
During our Alpha testing, before our rollout to clients, one of our testers
did the following:
1) They ran our program and it (the code I write Smilecreated the tables,
imported the data all fine and dandy.
The folder for the Elevate files tables, data, etc, say it was
C:\TestingElevate\DB
2) The Tester then moved the files to a different folder, say
C:\MyNewFolder\DB

The application then would not run because it could not find the folder
C:\TestingElevate\DB.

I do configure the Configpath at startup and this Configpath was pointed to
the new location.

I think I needed to do something with the catalog, but not sure what.

I reviewed information in this post:
http://www.elevatesoft.com/newsgrp?action=searchopenmsg&group=16&msg=2097&keywords=move*
catalog*#msg2097

I see the tables, but in the Manger, if I do a query, no data is returned.

FYI this link is broke:
http://www.elevatesoft.com/edb1d7_creating_configuration_objects.htm
The link above, is in this post:
http://www.elevatesoft.com/newsgrp?action=searchopenmsg&group=16&msg=2097&keywords=move*
catalog*#msg2097
Sat, Oct 24 2009 3:47 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Daniel


There are two things that the directory needs setting for: 1) the configuration files and 2) the database files

1) is set using the engine.ConfigPath IF UseLocalSessionEngineSettings is False or session.LocalConfigPath if True

This is the path to the .EDBCfg file

2) is set using SQL via an ALTER DATABASE statement and is the path to the .EDBCat file

Check that both these are correct and things should be OK

Also remember that EDBManager is just another app and that whilst ALTER DATABASE will affect your app if the same configuration file is pointed at the configuration information specified in EDBManager is only used in EDBManager and not in your app


Roy Lambert [Team Elevate]
Sat, Oct 24 2009 7:19 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Daniel,

Duplicate: answered via email.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Oct 26 2009 10:03 AMPermanent Link

"Daniel Kram"
The solution was to use the latest version or at least a newer version, of
the EDB server than I was using. Once I did this, then all I had to do was
issue the ALTER DATABASE "mydb" PATH 'mypath' command.
Image