| Subject | Re: [firebird-support] Firebird and mssql2005 |
|---|---|
| Author | Milan Babuskov |
| Post date | 2008-07-17T14:50:58Z |
goshen couture wrote:
Firebird database as external data source in MSSQL. After that you can
do simple INSERT/UPDATE/DELETE statements like:
insert into mssql.table1
select * from firebird.table1;
from MSSQL Enterprise Manager (or whatever it is called these days).
--
Milan Babuskov
http://www.guacosoft.com
> I want to do synchronization or transfer of data from Firebird 2.0(contain chinese character using unicode_fss) to MSSQL2005 and from MSSQL2005 back to Firebird 2.0.(contain chinese character using unicode_fss). How to do it ? Please advise.The easiest way is to use Firebird's ODBC driver and register the
Firebird database as external data source in MSSQL. After that you can
do simple INSERT/UPDATE/DELETE statements like:
insert into mssql.table1
select * from firebird.table1;
from MSSQL Enterprise Manager (or whatever it is called these days).
--
Milan Babuskov
http://www.guacosoft.com