2008年3月27日 星期四

Data movement from SQL Server to DB2


c:\>BCP Northwind.dbo.D_N_USER OUT D_N_USER.bcp -c -t, -q -U sa -P exim999 -S IBM-63AB93AA2BF


/*using DB2 CLP*/

connect to db2

C:\>db2 load client from D_N_USER.bcp of del modified by nochardel keepblanks insert into D_N_USER