I extracted data from MSSQL 2000 too with help of free utility SQL2GDB.
It is very handy and easy to use. In converts all metadata including
triggers, autoincrement fields etc. correctly. Moves data too. You can
find it at www.ibphoenix.com somewhere in the download section, I think.
Ales

> -----Original Message-----
> From: John Hart [mailto:macquarietc@...]
> Sent: Friday, February 22, 2002 12:58 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Mainly SQL help needed
>
>
> Hi,
>
> Sorry about the last email it somehow got sent before
> I even changed the subject.
>
> Thank you Helen, your last advice worked wonders but
> now I need some more help.
>
> 1) I want to extract data from an MSSQL 2000 batabase
> and load it into Interbase, it is very very slow about
> 10 records a second. Currently I use a Findnext loop
> (BDE) and in the loop Insert/Post to interbase (IBO).
>
> 2) How do I check, in Delphi, if a table or trigger
> etc exists.
>
> 3) How do I assign the result of 'Select count(*) from
> Student' to a Delphi variable.
>
> 4) How do I obtain the date from the 'Datepick'
> component.
>
> I borrowed three SQL manuals from the Uni library but
> they did not have the answer.
>
> Thank you
>
> John Hart
> Macquarie Training Centre
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Sports - Coverage of the 2002 Olympic Games
> http://sports.yahoo.com
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Sponsored by VeriSign - The Value of Trust
> When building an e-commerce site, you want to start with a
> secure foundation. Learn how with VeriSign's FREE Guide.
> http://us.click.yahoo.com/oCuuSA/XdiDAA/yigFAA/PhFolB/TM
> --------------------------------------------------------------
> -------~->
>
> ______________________________________________________________
> _____________
> IB Objects - direct, complete, custom connectivity to
> Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ______________________________________________________________
> _____________
> http://www.ibobjects.com - your IBO community resource for
> Tech Info papers,
> keyword-searchable FAQ, community code contributions and more
> !
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/