(SOLVED) Migrate Database
lazarus / 16-Databases

----------------------------------------------------------------------
InfoMan · 2012-06-14 00:21

I have a database with more than 8000 records in DBF format. I want to
migrate this database to another format. I thought about using
Firebird, but I have Firebird 2.1 installed on my machine because of
other programs we use. What do you recommend? Can I install Firebird
2.5, I develop the database in 2.1, or recommend me some other
database? I do not want to keep it in DBF offers no security.

Many thanks to all who respond.

----------------------------------------------------------------------
exdatis · 2012-06-14 05:35

Try:
http://www.clevercomponents.com/products/datapump/index.asp
I use Firebird 2.5 and SQLdb, works excellent!
You can't have two version of Firebird server on the same pc, but 2.1
is quite ok.
Also, you can make a simple app to import records using SQLdb.
Regards.
p.s. For me, PostgreSQL is also ok. Firebird, PostgreSQL, works well
on Win and Linux, and it's good choice.

----------------------------------------------------------------------
chrnobel · 2012-06-14 07:54

Why not consider SQLite?

SQLite can be used independently of your existing Firebird, and
especially when your database is so small, there is no need for a
larger database engine.

It seems like you have some security issues, so you should consider
addressing these either with controlling file access, and/or making a
security (login) mechanism in your program.

Also remember that if using the embedded version of Firebird there is
(aik) no security either.

BTW, I have made applications with around half a million records in
DBF files without problems.

/Christian

----------------------------------------------------------------------
BigChimp · 2012-06-14 08:03

I'd go with your existing Firebird as well. Even if you use Firebird
embedded, you can modify it to run client server with minimal code
changes (specify the hostname instead of an empty string).

You can run multiple Firebird servers on one machine, as long as you
let them listen on different ports.

Quite likely, the existing software will run just fine if you upgrade
to Firebird 2.5. However, as exdatis said, 2.1 is fine, too. You could
develop on 2.1, and occassionally test with an embedded 2.5 server -
or even 3.0 alpha builds

If you're worried about confidentiality, e.g. with embedded databases
(whether sqlite or Firebird), I'd think encryption initiated from your
client would be a step to tighten security a bit, but it's not
foolproof.
However, once somebody you may not trust has physical control of a
server or workstation, you cannot get total security in any case.

----------------------------------------------------------------------
exdatis · 2012-06-14 08:06

Over the time you may want to control the generator or procedure?
Regards.
p.s. Trigger, view, domain etc.

----------------------------------------------------------------------
exdatis · 2012-06-14 08:09

Quote from: BigChimp on June 14, 2012, 10:03:40 amYou can run multiple
Firebird servers on one machine, as long as you let them listen on
different ports.
I didn't know, thanks!

----------------------------------------------------------------------
InfoMan · 2012-06-14 20:56

Thank you all for the answers. My concern about the safety of DBF is
that our computer is networked, so anyone can access the computer data
and read the DBF file, because we need the program folder is shared so
that all people in our industry can access it. Simply access the
folder, and open the file that already have access to all data
programs, because you can not encrypt the database. I'll see what I do
probably migrate to SqlLite, but perhaps keep in DBF and let off the
network. More likely though is trying to use Firebird on another port.
Hopefully not take issue with other programs. Still, thanks to all.

----------------------------------------------------------------------
InfoMan · 2012-06-24 18:02

I decided to migrate the database to Firebird and so my problem was
resolved. Thank you for the help everyone.