Have you looked at MS SQL's DTS packages? My guess is you could easily
create a connection to FB and create a porting program.

I haven't got time to try this right now but I just ported my own app from
MSSQL to FB, so I'm travelling the same road in the other direction.

Aaron



-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Chad Z. Hower aka
Kudzu
Sent: Friday, April 15, 2005 5:27 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] FB to SQL Server


First don't worry, Im not abandoning FB. :)

But I need an easy way to take my FB DB and export it to a new SQL DB. I
just need the schema, but data would be nice too. Im doing all the work in
FB, but it's a system that some users are using SQL server and want my
system to use that, so I need to provide both. But I don't want to maintain
both manually.

Also I need it to be automatic - not a case tool or something. Something I
can just run and poof it deletes the old SQL DB, then reads the FB ones and
makes "copy" in SQL Server.

Anything out there?

--
Chad Z. Hower aka Kudzu
"Programming is an art form that fights back"

Still doing your website by hand? Get a free content management system:
http://www.atozed.com/iws/




Yahoo! Groups Links