I have an SQL Server database that is around 10 gigabytes in size
which I am transferring to firebird. The database is currently on my
home system which is connected to the internet via a cable modem.
Since I'm not real confident about transferring the data directly from
SQL Server to the firebird server (again because the connection is
only a cable modem), I was planning to create a series of text files
which contain many insert commands.

In order to help speed it along I was planning to do a commit every
1000 inserts or so. Is this what is meant by a "bulk insert" - just
not doing a commit too frequently?

I was planning to zip the completed txt files up and ftp them to the
firebird server and then run them as SQL script files in EMS IB
Manager.

Is that the quickest way to do this?

Also, I noticed when running the SQL script file in EMS IB Manager
that the inserts happen very quickly at the start of the file, but
that they slow considerably near the end of a long script (5 or 10 MB
in size). Would it be quicker overall if I worked with smaller script
files (say a megabyte or so)?

Can you run a script file via isql or some other similar program that
comes with firebird?

Thank you for you input.