Hi all, I have a situation where a local client's dbase is running on Firebird 2.5, The Corporates main servers are in SA and they run M$ SQL 2005. There is a need to create a web interphase for this dbase. They want specific tables that will be needed for the web interphase to be hosted on M$ SQL, so the need for inter dbase replication comes in place. Anyone with any info on how this can be done. Firebird - M$SQL Replication. -- Regards, Zack K. Githinji Cell:+254 722 649199 "God grant me the serenity to accept the things I cannot change, the courage to change the things I can, and the wisdom to know the difference."
Hie zac Try these tool EMS Data Export 2007 for InterBase Firebird 3.0.0.7 you can download it from here Key Features - Exporting data to 19 most popular formats: MS Excel, MS Access, MS Word, RTF, HTML, PDF, XML, TXT, DBF, CSV, ODF, SYLK, DIF, LaTeX, SQL, Clipboard and others - Exporting data from several tables, views or queries at the same time - Selecting fields to export and changing their order - Adjustable parameters for each exported table and specific parameters for each output format - Saving all export parameters set on current wizard session to the configuration file - Command-line utility to automate your export jobs using the configuration file - Latest InterBase/Firebird version support - Connecting via local port forwarding through the SSH tunnel - User-friendly wizard interface http://rapidshare.com/files/99667318/EMS.Data.Export.2007.for.InterBase.Fire... Good luck
Zack, In what platforms? Use DBD::InterBase to connect Firebird to your perl cgi's. Use DBD::ODBC to connect M$SQL to your perl cgi's As long as you can fix the DBD right! the rest work like magic. Regards, Oj. The optimist sees the doughnut; the pessimist the hole. --- On Thu, 8/6/09, Zack Githinji <zachgithinji@gmail.com> wrote: From: Zack Githinji <zachgithinji@gmail.com> Subject: [Skunkworks] Replication To: "Skunkworks forum" <skunkworks@lists.my.co.ke> Date: Thursday, August 6, 2009, 12:36 AM Hi all, I have a situation where a local client's dbase is running on Firebird 2.5, The Corporates main servers are in SA and they run M$ SQL 2005. There is a need to create a web interphase for this dbase. They want specific tables that will be needed for the web interphase to be hosted on M$ SQL, so the need for inter dbase replication comes in place. Anyone with any info on how this can be done. Firebird - M$SQL Replication. -- Regards, Zack K. Githinji Cell:+254 722 649199 "God grant me the serenity to accept the things I cannot change, the courage to change the things I can, and the wisdom to know the difference." -----Inline Attachment Follows----- _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
Firebird is running on Win 2003 Server.. and ofcourse the M$SQL... On Thu, Aug 6, 2009 at 11:44 AM, Oj G <ojiwaj@yahoo.com> wrote:
Zack,
In what platforms?
Use DBD::InterBase to connect Firebird to your perl cgi's. Use DBD::ODBC to connect M$SQL to your perl cgi's
As long as you can fix the DBD right! the rest work like magic.
Regards, Oj.
The optimist sees the doughnut; the pessimist the hole.
--- On *Thu, 8/6/09, Zack Githinji <zachgithinji@gmail.com>* wrote:
From: Zack Githinji <zachgithinji@gmail.com> Subject: [Skunkworks] Replication To: "Skunkworks forum" <skunkworks@lists.my.co.ke> Date: Thursday, August 6, 2009, 12:36 AM
Hi all,
I have a situation where a local client's dbase is running on Firebird 2.5, The Corporates main servers are in SA and they run M$ SQL 2005. There is a need to create a web interphase for this dbase. They want specific tables that will be needed for the web interphase to be hosted on M$ SQL, so the need for inter dbase replication comes in place. Anyone with any info on how this can be done. Firebird - M$SQL Replication.
-- Regards, Zack K. Githinji
Cell:+254 722 649199
"God grant me the serenity to accept the things I cannot change, the courage to change the things I can, and the wisdom to know the difference."
-----Inline Attachment Follows-----
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke <http://mc/compose?to=Skunkworks@lists.my.co.ke> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
-- Regards, Zack K. Githinji Technical Officer, Cell:+254 722 649199 E-mail:zachgithinji@gmail.com <E-mail%3Azachgithinji@gmail.com> "God grant me the serenity to accept the things I cannot change, the courage to change the things I can, and the wisdom to know the difference."
participants (3)
-
Benjamin -
Oj G -
Zack Githinji