Greetings all,
I would like help with how to do a one time import of data from
Interbase to MsSQL.
kindness
Abby
Hi
Look at SQL Server 2000's DTS ("Import and Export Data" in the SQL Server
Windows Menu)
With a Interbase driven installed on a machine, you can have DTs move the
data for you.
Books Online has a lot of information in DTS.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"abby" <abby@.trolling.org> wrote in message
news:cv5fc1$85n$1@.ctb-nnrp2.saix.net...
> Greetings all,
> I would like help with how to do a one time import of data from
> Interbase to MsSQL.
> kindness
> Abby
|||Mike Epprecht (SQL MVP) wrote:
> Hi
> Look at SQL Server 2000's DTS ("Import and Export Data" in the SQL Server
> Windows Menu)
> With a Interbase driven installed on a machine, you can have DTs move the
> data for you.
> Books Online has a lot of information in DTS.
I assume you meant an Interbase ODBC driver installed on the machine?
As this will be a onetime transfer I am trying to avoid having to
purchase such a driver for one time use.
Thanks
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "abby" <abby@.trolling.org> wrote in message
> news:cv5fc1$85n$1@.ctb-nnrp2.saix.net...
>
>
|||Hi
All the tools the MS supply rely on a ODBC driver for the source DB. The
ODBC driver understands the source, and the tools then just have to do the
manipulation.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"abby" <abby@.trolling.org> wrote in message
news:cv6e7k$dql$1@.ctb-nnrp2.saix.net...[vbcol=seagreen]
> Mike Epprecht (SQL MVP) wrote:
Server[vbcol=seagreen]
the[vbcol=seagreen]
>
> I assume you meant an Interbase ODBC driver installed on the machine?
> As this will be a onetime transfer I am trying to avoid having to
> purchase such a driver for one time use.
> Thanks
>
|||Mike Epprecht (SQL MVP) wrote:
> Hi
> All the tools the MS supply rely on a ODBC driver for the source DB. The
> ODBC driver understands the source, and the tools then just have to do the
> manipulation.
Thanks
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "abby" <abby@.trolling.org> wrote in message
> news:cv6e7k$dql$1@.ctb-nnrp2.saix.net...
>
> Server
>
> the
>
>
No comments:
Post a Comment