SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 05:14 PM
| ||||
| ||||
 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      |
|
04-24-2008, 06:07 PM
| ||||
| ||||
| RE: Import help I connect via ODBC through Excel's Data Connections(using the same connection string that you used to connect in SQL), from there under Connection Properties there is an "Edit Query" button. This opens up Microsoft Query, which is quick way to build SQL Queries which you can then copy and paste into SQL during the import process. If you can't find what I'm referring to, I can send you screenshots. |
Linear Mode
