Sybase Data Export

1. SQL`den

SELECT * FROM DBA.THREAT; OUTPUT TO c:tempdene.txt;

2. Linux/Dos Command Line`dan

dbisqlc -c “DSN=SEDSN;DBN=sem5;UID=DBA;PWD=1234;” -q run.sql > data.txt

dbupload -c “DSN=SEDSN;DBN=sem5;UID=DBA;PWD=1234;”  -t tableismi -q

-t table parametresi verilmesse database full export edilmis olur

-q mesaj ve pencerelerin cikmamasi icin

2.sql icinden output ile data export etmek

dbisqlc -c “DSN=SEDSN;DBN=sem5;UID=DBA;PWD=1234;” -q run.sql

run.sql icerigi :

SELECT * FROM DBA.THREAT; OUTPUT TO c:tempdene.txt;