June 22, 2010 at 2:17 pm
Sofar We are providing the db data to client in excel files using import/export wizard in sql server 2005.
Now client is asking the tables data in saperate CSV files in unix format. is it possible?
As far as I know SQL Server 2005 runs on Windows system. Please advice
June 22, 2010 at 4:14 pm
Hi,
You can use the same export data tool, but choose Flat File Destination and make sure to select LF as the row delimiter.
If it has worked, when you open one of the text files in Notepad, it will all be one long line, whereas in Wordpad it will be one line per row of data.
Make sure you transfer the files in Binary mode if using FTP or zip them up before sending so that they are not modified to include a CR-LF line ending.
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);
June 23, 2010 at 7:56 am
Thank you,
But how to convert the CSV windows file into CSV (Unix format). Is there any feature in SQL Server, or any third party tools? Please let me know.
In our database there are 250+ tables.
June 23, 2010 at 8:51 am
laddu4700 (6/23/2010)
Thank you,But how to convert the CSV windows file into CSV (Unix format). Is there any feature in SQL Server, or any third party tools? Please let me know.
In our database there are 250+ tables.
Changing the row delimiter to only LF makes it compatible with Unix.
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);
June 23, 2010 at 8:59 am
Thanks Magoo,
June 23, 2010 at 12:46 pm
mister.magoo (6/23/2010)
laddu4700 (6/23/2010)
Thank you,But how to convert the CSV windows file into CSV (Unix format). Is there any feature in SQL Server, or any third party tools? Please let me know.
In our database there are 250+ tables.
Changing the row delimiter to only LF makes it compatible with Unix.
If Understood correct,
I need to select the file.csv
format : delimited
select: column names in the first data row
row delimited: LF
Column delimiter: Comma {,}
So output CSV file is compatible with Unix, Please correct me If I am wrong.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply