Ternyata export import data lebih mudah di linux dibanding Windows, beberapa hari ini nyari caranya ternyata sangat mudah via Linux...
Pertama install dulu python dan pymssql
sudo apt-get install python2.5 python-pymssql python-csv
test dulu diterminal seperti ini
python
>>>import pymssql ,csv
>>>
kalau tidak ada error berarti packagenya sudah terinstall dengan baik.. selanjutnya ngoding, buat file test.py
##############
# test.py #
##############
import pymssql , csv
conn = pymssql.connect(host='IP SQL server' , user='sa', password='password sa', database='nama databasenya') # connection to database
cur = conn.cursor() # set cursor
writer = csv.writer(open('export.csv','wb')) # Declaration for CSV file and CSV Object
cur.execute( 'select * from table1 ') # Execute query
row = cur.fetchall(row) # Retrieve result in tuple object
writer.writerows(row) # Write row Object into csv file
conn.close # close database connection
Selesai.. mantab kan ... cuman < 10 baris doank ... hehehehehehe
Pertama install dulu python dan pymssql
sudo apt-get install python2.5 python-pymssql python-csv
test dulu diterminal seperti ini
python
>>>import pymssql ,csv
>>>
kalau tidak ada error berarti packagenya sudah terinstall dengan baik.. selanjutnya ngoding, buat file test.py
##############
# test.py #
##############
import pymssql , csv
conn = pymssql.connect(host='IP SQL server' , user='sa', password='password sa', database='nama databasenya') # connection to database
cur = conn.cursor() # set cursor
writer = csv.writer(open('export.csv','wb')) # Declaration for CSV file and CSV Object
cur.execute( 'select * from table1 ') # Execute query
row = cur.fetchall(row) # Retrieve result in tuple object
writer.writerows(row) # Write row Object into csv file
conn.close # close database connection
Selesai.. mantab kan ... cuman < 10 baris doank ... hehehehehehe
Powered by ScribeFire.
Tidak ada komentar:
Posting Komentar