Subject | Re: [Firebird-general] Migration from Ms-sql to Firebird call to story |
---|---|
Author | Milan Babuskov |
Post date | 2006-09-28T17:33:49Z |
Philippe Makowski wrote:
anything equivallent to MSSQL's BCP (bulk copy program) - which can be
used to dump and load data really fast (ignores transaction control and
constraints). The closest thing in FB are external tables, but it has
problems with NULL values and doesn't support BLOBs (this is the reason
I wrote FBExport tool, but it is much slower).
--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org
> we have an opportunity to have a session at Solution Linux 2007 (Paris)Oh, I forgot, and it may also be interesting. Firebird does not have
> I will talk about migration from MsSQL to Firebird
> but I need some material, if you can give me some specific details about your
> experience of this kind of migration, I will be pleased .
anything equivallent to MSSQL's BCP (bulk copy program) - which can be
used to dump and load data really fast (ignores transaction control and
constraints). The closest thing in FB are external tables, but it has
problems with NULL values and doesn't support BLOBs (this is the reason
I wrote FBExport tool, but it is much slower).
--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org