Groups | Blog | Home
all groups > sql server odbc > february 2005 >

sql server odbc : Interbase


abby
2/18/2005 9:23:49 PM
Greetings all,

I would like help with how to do a one time import of data from
Interbase to MsSQL.

kindness
Mike Epprecht (SQL MVP)
2/18/2005 10:35:34 PM
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/

[quoted text, click to view]

abby
2/19/2005 6:10:32 AM
[quoted text, click to view]


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


[quoted text, click to view]
Mike Epprecht (SQL MVP)
2/19/2005 12:32:24 PM
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/

[quoted text, click to view]

abby
2/19/2005 2:49:29 PM
[quoted text, click to view]

Thanks



[quoted text, click to view]
AddThis Social Bookmark Button