Subject Re: [firebird-support] Migrate from Firebird to MSSQL2005
Author goshen couture
Hi Thomas,

Thanks for your info. I want to do two -way process consolidating data from firebird databases to one mssql2005 database and then from mssql2005 transfer back data to firebird databases. so do i need to use both kettle/talend and intergration services ?

inside the feature components for integration service it has mssql2000 dts designer component do i need that ?
i already have the dts for mssql2005 but it is still not showing in the mssql2005 ?

my firebird database consist of chinese charater in unicode_fss , does mssql2005 able to display that after being transfer using kettle/talend ? and likewise does firebird able to display the chinese character from mssql2005 after the data being transfered back ? thanks

Halim S

Thomas Steinmaurer <ts@...> wrote: > i use ibpump for manual data transfer but i need auto and programmable data transfer tool.
> I have used data transformation service in mssql2000 to do data transfer but in mssql2005 i cant find the dts what method should i use ? another issue is how to transfer chinese char unicode_fss from firebird to mssql2005 and from mssql2005 back to firebird ? please advise thanks

If it is a one-way process, e.g. moving transactional data from a
Firebird database into a MSSQL based data warehouse, then any ETL Tool
like "Kettle" or "Talend" could do the job. We have been using Kettle
lately and IMHO, it is a very nice open source product, but I have also
heard good things about Talend.

In MSSQL 2005, the ETL product is called "Integration services".

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions

Get your new Email address!
Grab the Email name you've always wanted before someone else does!

[Non-text portions of this message have been removed]