Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Upgrade from V4 to ElevateDB guide
Mon, May 21 2007 2:57 AMPermanent Link

"e"
Hi,

Is there a upgrade map to migrate from V4 to ElevateDb ?. Including any
SQL changes etc?.


I would also like to use ElevateDB in the same manner I currently use
DBISAM, sort of a pseudo file format.

My file that users open in the application is actually a dbisam
database backup which is renamed to my file extenstion.

When they go file open, I restore the backup, set the dbisamdatabase to
this folder and presto it all works.

Can I do this exact behaviour in ElevateDB?. I got the impression that
ElevateDB needed to be installed, in a similar manner to SQL Server?,
or did I get the wrong end of the stick,

Cheers
Clive.
Mon, May 21 2007 4:47 PMPermanent Link

Lance Rasmussen

Jazzie Software

Avatar

Team Elevate Team Elevate

Do you mean this?

http://www.elevatesoft.com/edb1d2007.htm

"DBISAM Migration"

Lance

<e> wrote in message
news:484E38E2-4109-4F7B-95A6-A89357444E3F@news.elevatesoft.com...
> Hi,
>
> Is there a upgrade map to migrate from V4 to ElevateDb ?. Including any
> SQL changes etc?.
>
>
> I would also like to use ElevateDB in the same manner I currently use
> DBISAM, sort of a pseudo file format.
>
> My file that users open in the application is actually a dbisam
> database backup which is renamed to my file extenstion.
>
> When they go file open, I restore the backup, set the dbisamdatabase to
> this folder and presto it all works.
>
> Can I do this exact behaviour in ElevateDB?. I got the impression that
> ElevateDB needed to be installed, in a similar manner to SQL Server?,
> or did I get the wrong end of the stick,
>
> Cheers
> Clive.
Tue, May 22 2007 9:20 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Clive,

<< Is there a upgrade map to migrate from V4 to ElevateDb ?. Including any
SQL changes etc?. >>

Yep, right here:

http://www.elevatesoft.com/edb1d7_dbisam_migration.htm

<< I would also like to use ElevateDB in the same manner I currently use
DBISAM, sort of a pseudo file format.

My file that users open in the application is actually a dbisam database
backup which is renamed to my file extenstion.

When they go file open, I restore the backup, set the dbisamdatabase to
this folder and presto it all works.

Can I do this exact behaviour in ElevateDB?. I got the impression that
ElevateDB needed to be installed, in a similar manner to SQL Server?, or did
I get the wrong end of the stick, >>

You'll also have to deal with the configuration file in ElevateDB, which is
used to store the database, user, role, and job definitions:

http://www.elevatesoft.com/edb1sql_architecture.htm

Just set the TEDBEngine.ConfigPath to the same directory as your
application's executable file (or choose a directory in the Windows
application data folder) and that is where EDB will store the configuration
file.  Then you'll need to create the database using the CREATE DATABASE
statement:

http://www.elevatesoft.com/edb1sql_create_database.htm

So that the database name points to the proper directory where the database
is stored.  Then you can use the BACKUP/RESTORE DATABASE statements to
perform your backup/restore functionality:

http://www.elevatesoft.com/edb1sql_backup_database.htm
http://www.elevatesoft.com/edb1sql_restore_database.htm

Other than that, the rest is essentially the same.

--
Tim Young
Elevate Software
www.elevatesoft.com

Sat, May 26 2007 2:56 PMPermanent Link

Clive
Time to bite the bullet I think !

BTW, the restore html page contains references to Compression from the Backup page.
Cut and paste overload Smile

Cheers
Clive.

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Clive,

<< Is there a upgrade map to migrate from V4 to ElevateDb ?. Including any
SQL changes etc?. >>

Yep, right here:

http://www.elevatesoft.com/edb1d7_dbisam_migration.htm

<< I would also like to use ElevateDB in the same manner I currently use
DBISAM, sort of a pseudo file format.

My file that users open in the application is actually a dbisam database
backup which is renamed to my file extenstion.

When they go file open, I restore the backup, set the dbisamdatabase to
this folder and presto it all works.

Can I do this exact behaviour in ElevateDB?. I got the impression that
ElevateDB needed to be installed, in a similar manner to SQL Server?, or did
I get the wrong end of the stick, >>

You'll also have to deal with the configuration file in ElevateDB, which is
used to store the database, user, role, and job definitions:

http://www.elevatesoft.com/edb1sql_architecture.htm

Just set the TEDBEngine.ConfigPath to the same directory as your
application's executable file (or choose a directory in the Windows
application data folder) and that is where EDB will store the configuration
file.  Then you'll need to create the database using the CREATE DATABASE
statement:

http://www.elevatesoft.com/edb1sql_create_database.htm

So that the database name points to the proper directory where the database
is stored.  Then you can use the BACKUP/RESTORE DATABASE statements to
perform your backup/restore functionality:

http://www.elevatesoft.com/edb1sql_backup_database.htm
http://www.elevatesoft.com/edb1sql_restore_database.htm

Other than that, the rest is essentially the same.

--
Tim Young
Elevate Software
www.elevatesoft.com

Sat, May 26 2007 6:48 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Clive,

<< BTW, the restore html page contains references to Compression from the
Backup page. Cut and paste overload Smile>>

Yep, it's now fixed.

There's also a "copy and paste" error in the Backing Up and Restoring
Databases topic in the compiler-specific manual - it references the old
TDBISAMDatabase.Restore method. Frown

--
Tim Young
Elevate Software
www.elevatesoft.com

Image