Bin File - General SQL Database Question & Answer - LearnSqlServer.com's SQL Server Forums

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » General SQL Database Question & Answer » Bin File

Bin File

Options

Previous Topic · Next Topic

xoxo23

Posted: Tuesday, April 15, 2008 10:06:41 AM

Rank: Newbie

Joined: 2/18/2008
Posts: 4
Points: 12
Location: Indonesia

Hi,All. I need help. I need to import .bin file from db2 database to the sql server database. Could SQL server do the import?If it could,could you please tell me how to do it.Thank You

Scott Whigham

Posted: Wednesday, April 16, 2008 9:25:53 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

Uhhh - what exactly is a .bin file? I know what a .bin file is if you gave me an .iso file but I don't know what db2 uses a .bin file for Frown

xoxo23

Posted: Sunday, April 27, 2008 10:36:43 AM

Rank: Newbie

Joined: 2/18/2008
Posts: 4
Points: 12
Location: Indonesia

I am sorry that I didn't provide any sample of the BIN file. It has the fixed width length and also can be open in notepad like in the sample below,

Sample of BIN File 1
84948484848484 393939393939 39484439499494 9494938393993387548794FORK&SPOON Hhdhhdhhdhdhdhd 8738383838383 76577656124676765 67665fgg5t677
74378383732099 939393939384 84394949393939 9394894949494848594949FORK&SPOONWS dshdhdhdhdhdhdh 7383748474874 838383748484u4848 hdue874894949

Sample of BIN File 2
11111111111111111222222222222 22222222222222221111111133333333333 OIJHDNDHNDHDHDBDH
83838383838373847448847438484 72263543647637373837337377373733737 hdhdhdbdy3ehdhssh

Could the SQL server import this file to the SQL Server Database? If it can,How to do it?this file is so different from what I learn the import file from my school which I am using CSV file. Thank You.

Scott Whigham

Posted: Tuesday, April 29, 2008 7:28:29 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

Thanks. Yes, you could import that data. You have several choices and, for complete coverage, I would recommend this series: An Introduction to Bulk Operations, Flat Files, and Tools in SQL Server. Basically you can use bcp, SSIS, BULK INSERT, or OPENROWSET to import. Which one should you use? I can't answer that! Too many variables and not enough input Smile

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.