On Sat, 2006-10-07 at 13:55 +0800, Ow Mun Heng wrote: > Hi, > > Anyone here familiar with sqsh? > I'm trying to get bcp going here for replication between a MSSQL > server(2000) to a MySQL server (5.0). > > Since I've not found any "decent" way to do the replication, I'm now > using sqsh to do it via the CLI. > > $sqsh -S Server -U user -i ~/bcp.txt -L bcp_colsep=',' -L datetime='%Y-% > m-%d %H:%M:%S' > > then using mysql's load data infile to do the inputing. > > I have a problem in that NULL values are not being returned as NULL. > > eg: the outputing bcp file will be > > AAA,2006-07-09 12:00:00,,BBB > > the field between the date and "BBB" is being treated as blank instead > of NULLs and I'm getting into a problem here. > > Does anyone here has any pointers on how to get sqsh to output the > fields as NULL eg: > AAA,2006-07-09 12:00:00,NULL,BBB
I found the solution. See here http://lotso.livejournal.com/81385.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]