Greetings all,
I would like help with how to do a one time import of data from
Interbase to MsSQL.
kindness
AbbyHi
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