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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
