Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 10 of 11 total |
change db path problem !! |
Thu, Jun 12 2008 4:55 PM | Permanent Link |
Isaac | Hello
I read the FAQ that tell I have to use alter database so I can changes so I created a new fold in c:\ drive and copy all files and change the path with the database manager but I did not find the tables I created !! I return to previous folder still can see the tables I created !! What I should ? I hope you come in better solution for changing the database path. Thanks |
Thu, Jun 12 2008 5:32 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Isaac,
<< I read the FAQ that tell I have to use alter database so I can changes so I created a new fold in c:\ drive and copy all files and change the path with the database manager but I did not find the tables I created !! >> You probably didn't copy the edbdatabase.edbcat catalog file also. You need to copy this database catalog file to the new folder also or the tables will not be visible since the database catalog determines whether the tables "exist" or not, not the table files themselves. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Jun 12 2008 5:47 PM | Permanent Link |
Isaac | Tim Young [Elevate Software] wrote:
> > You probably didn't copy the edbdatabase.edbcat catalog file also. You need > to copy this database catalog file to the new folder also or the tables will > not be visible since the database catalog determines whether the tables > "exist" or not, not the table files themselves. > - ok but I am almost sure I copied all files, but in case I copied a wrong file and the original file deleted "accidentally" - is there a way to get the table back to the database ? - What I should do so any user can move the application data and still able to open the database and work on the application ? Thanks |
Thu, Jun 12 2008 6:55 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Isaac,
<< - ok but I am almost sure I copied all files, but in case I copied a wrong file and the original file deleted "accidentally" - is there a way to get the table back to the database ? >> If you delete the catalog, then the only way to get access to the data again is to restore a backup. I could rebuild the catalog for you to match the tables again, but I would have to charge you for this because it would take literally hours to reset all of the object IDs and version numbers so that they match properly. << What I should do so any user can move the application data and still able to open the database and work on the application ? >> Make sure to copy the catalog over also, and make sure that you have a good backup because if you're allowing users to copy around database files, they'll most definitely accidentally delete something important in the process. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Jun 12 2008 7:04 PM | Permanent Link |
Isaac | Tim Young [Elevate Software] wrote:
> > Make sure to copy the catalog over also, and make sure that you have a good > backup because if you're allowing users to copy around database files, > they'll most definitely accidentally delete something important in the > process. > It is common for application to be moved by users however, what about the alter database ? should I use it ? if so when I should use it for example in every application start up ? |
Thu, Jun 12 2008 9:12 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Isaac,
<< It is common for application to be moved by users however, >> Really ? Most applications don't respond very well when they are moved around manually by just copying their files. << what about the alter database ? should I use it ? >> Sure, it does what it is supposed to do - alter the database information. << if so when I should use it for example in every application start up ? >> That's up to you, but I would only use an ALTER DATABASE statement if the database path is *not* correct. You can find this out by querying the Databases table in the system Configuration database: http://www.elevatesoft.com/manual?action=mantopic&id=edb2&product=d&version=7&category=4&topic=13 http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=3&topic=55 Just check the Path column for the desired database against the path that you expect it to be at, and if the two don't match, use an ALTER DATABASE statement to modify the path for the database. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Jun 13 2008 2:28 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Isaac
>It is common for application to be moved by users however, I don't know a lot of multi-user database applications where the application and its data are moved around much. Even for single user stuff its more normal for it to sit still once its up and running. Its more normal for the application to be installed in a different location to which the developer used. Is that what you're talking about? If so do you provide data as part of the installation? Roy Lambert [Team Elevate] |
Fri, Jun 13 2008 8:29 AM | Permanent Link |
Isaac | Tim Young [Elevate Software] wrote:
> Isaac, > > << It is common for application to be moved by users however, >> > > Really ? Most applications don't respond very well when they are moved > around manually by just copying their files. > > << what about the alter database ? should I use it ? >> > > Sure, it does what it is supposed to do - alter the database information. > > << if so when I should use it for example in every application start up ? >> > > That's up to you, but I would only use an ALTER DATABASE statement if the > database path is *not* correct. You can find this out by querying the > Databases table in the system Configuration database: > > http://www.elevatesoft.com/manual?action=mantopic&id=edb2&product=d&version=7&category=4&topic=13 > http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=3&topic=55 > > Just check the Path column for the desired database against the path that > you expect it to be at, and if the two don't match, use an ALTER DATABASE > statement to modify the path for the database. > ok - it is required from me to make the application portable in fact this why I am using elevatedb otherwise I would go for oracle , the data is shipped with the application so user may copy the application any where I hope as a feature request for this to be done automatically in future releases Thanks |
Fri, Jun 13 2008 8:30 AM | Permanent Link |
Isaac | Roy Lambert wrote:
> If so do you provide data as part of the installation? > > Roy Lambert [Team Elevate] Yes read my previous post Thanks |
Fri, Jun 13 2008 10:13 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Isaac
>ok - it is required from me to make the application portable in fact >this why I am using elevatedb otherwise I would go for oracle , the >data is shipped with the application so user may copy the application >any where That's not to difficult. I was thinking about a situation where the users were copying the data round as the mood took them. I'm guessing that your install program will all them you pick a directory into which the app goes and the data will either go into the same directory or a sub-directory (or if Vista is a target one of the allowed sub-directories eg Program Data). If so then assuming you've copied and installed the appropriate files on app start up use IncludeTrailingPathDelimiter(ExtractFilePath(Application.ExeName)); to get the "root" path, add your extension to it and use that to set the database path. >I hope as a feature request for this to be done automatically in future >releases I wish I knew how that could be done, I could use it in a number of my apps but without a single file system holding the tables, catalog and preferably the program code I don't know how. Maybe Tim does but I'm not holding my breath <vbg> Roy Lambert [Team Elevate] |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |