Import help We recently purchased a new SQL 2005 server that I need to import a DB from
another server. in order to connect to the "other" server I have to use a
3rd party thoroughbred odbc driver. On our old SQL2000 box to perform this
task I would select import and next to data source I could select the
thoroughbred drivers and do the import. I have installed the thoroughtbred
drivers on the new SQL2005 server. I can see them under administrative
tools/ ODBC. When I try and do an import of the database I am unable to
select the Thoroughbred ODBC driver under data source. I was able to use the
..net framework data provider and then add in the correct ODBC driver but
then I am prompted to write a script for the rest. Is there not an easier
way to do this? I am very new to SQL. I dont know much about writing queries
and scripts for SQL. I am hoping that there is an easier way to make this
happen. Please help.
TIA |