Build data link by import/ export wizard

SamSam
2 min readMay 27, 2019

--

SQL server import and export wizard

這個選項基本上算是DDL好用。如果資料不大,不會connection timeout,小弟會建議使用這個方式。連table都幫你建好了呢~

a. choose source
.Net Framework Data Provider for Odbc

b. key in Data ConectionString
ConnectionString:
DSN=NetSuite;UID=****;PWD=****
c. key in Driver
NetSuite Drivers 64bit (this case 32bit does work well)

d. choose destination
Microsoft OLE DB Provider for SQL Server

e. choose server name
d. choose authentication
e. choose database
f. specify table copy or query
Copy data from one or more tables or views (up to you)

g. select source tables and views
* edit column mappings and data type

* preview

h. convert types without conversion checking
Next

i. save and run package

j. Complete the wizard
Run DDL and successfully create a new table in destination

--

--

SamSam
SamSam

Written by SamSam

用有限的資料知識探索無限的世界

No responses yet