Archive

Archive for the ‘Tools’ Category

Can you identify file type without extension

November 17, 2016 Leave a comment

We may come across this situation when we get a file with out extension or given incorrectly. But, we have options in some operating system that will search and match the program associated with the unknown file type.

I had situation recently, a file with incorrect extension. I was trying to open the file in text edition (binary mode) to identify the file type manually. But, I could not do it simple reading the file content.

Finally found a tool that does what i was trying to do manually. This is light weight tool with easy to update external data dictionary for file finger print matching data.

Utility software details:

TrID

is free for personal / non commercial use.

URL: http://mark0.net/soft-trid-e.html

Direct download:

TrID is free for personal / non commercial use.

 Win32  TrID v2.24, 47KB ZIP(PGP sig)
 Linux/x86  TrID v2.24, 357KB ZIP(PGP sig)
 Linux/x86-64  TrID v2.24, 421KB ZIP(PGP sig)
 TrIDUpdate v1.00, 1KB ZIP (Python 2.7.x required)
 TrIDDefs.TRD package, 982KB ZIP (7647 file types, 15/11/16)

DBF Viewer and Converter – Utility Software

June 27, 2014 1 comment

DBF is a database file format and it is one of the oldest and successful data storage in the past and present. This blog post is just to introduce a utility software called MyDBFViewer. This is used to view dbf files and convert it to CSV format with simple button clicks. Please download and use this software and share your feedback in the comment section.

Sample screen of the software:

pic1

Software Manual:

Step 1: Select a DBF file using Select file button or type the file path in the text box.

Step 2: Click Browse Data button to load the data on the screen.

Step 3: Click Export to CSV button for exporting data to CSV file. To perform this step you have to complete Step 2.

DBF file used in this demo is available here.

Note: Please download and rename the file MyDBFViewer.pdf to MyDBFViewer.exe

Categories: Tools Tags: , , ,

Discover all SQL Servers on the Network – Searching SQL Server

April 24, 2014 2 comments

Finding all SQL Server on the network.

This is a simple SQL utility software that helps to discover SQL Servers that are installed and broadcasting on the local network and in the local machine.

Download DiscoverSQLServers Now

(Please change the file extension. It is named as DiscoverSQLServers.pdf, but we have to rename to DiscoverSQLServers.exe)

pic1

This tool has three sections

Section 1: Discover SQL Servers, To start the search we have to press the “Start Discover” button. After the search is completed, all server names with instance name will be listed in list box. We can select a sever name from this list to construct the connection string.

Section 2: This is a table that will load all server name, instance name, flag for clustered server and version number. This details help us to understand our SQL Server environment.

Section 3: This is a simple but powerful section to auto construct the connection string for the selected server. In this section, we can test the validity of the connection string by pressing “Test Connection” button and by default, it will build the trusted connection. But, we can change that to SQL authentication by simply check the “SQL Authentication” option. It will pop-up user input dialog box for username and password. We can also copy the connection string to the clipboard to paste it in your code.

This is simple but powerful tool available for download.

Download DiscoverSQLServers Now

(Please change the file extension. It is named as DiscoverSQLServers.pdf, but we have to rename in to DiscoverSQLServers.exe)

Please write your review about this tool in the comment section. I am glad to hear from you. Thank you.

Other tools that can be used for this purpose

SQLO  – it will be deprecated in future version.

SQLcmd

MAP – Microsoft Assessment and Planning (MAP) Toolkit

Graphical Interface for BCP – SQL Server Utility Software

April 22, 2014 1 comment

Data Export and Import tool

BCP – It is a utility software comes with Microsoft SQL Server. It is a command line tools and very helpful for data transfer between files and SQL tables. It is the simplest and fastest way to transfer data between SQL Instance or different DBMS with data files.

By default, BCP output file does not contain the file formatting or data type information. So, we have create the format file for the data we export using this utility. Other wise, we will not be able to import the data back to SQL Server table.

For more information, please refer Microsoft TechNet documentation.

GBCP – Graphical BCP – Download now

It is a simple 4 step process to Export/Import data in SQL Server. This interface will remove the pain of typing the BCP command in command prompt interface for execution.

This tool is mainly developed to provide an interface for command line BCP utility. GBCP will not replace the original BCP. Because, BCP is the core utility developed and available with SQL Server. So, Users should aware of this before downloading this graphical user interface for BCP.  GBCP executes the currently mapped version of BCP utility in the user’s computer. Because, we may have multiple versions of BCP utility in a machine if we installed multiple versions of Microsoft SQL Server.

GBCP interface does cover only the basic options available in BCP utility. In the future release, GBCP will have all options to help users to use this interface extensively.

Demonstration

User Interface of GBCP utility

pic1

1. SQL Connection

  • Fill SQL Server connection information and connect to server

2. Select the BCP option

  • in (Import data in to a table)
  • out (Export data to a file)
  • queryout (SQL Query data export to a file)
  • format (Create Format File)

3. Select database objects

  • This is an editable object selection text box. We can select the existing table or view for export or give a table name for import.

4. BCP operation setup box for each BCP option

  • This setup box will show all necessary options and file location text box to create output file, format file and etc.

BCP Generic Option

These are the BCP options used internally by BCP. We can specify the new value to override the default value while executing the BCP command.

BCP Command

This is a multiline text box that will have the full BCP command that is executed. It is given to user for reference.

Error File

Error file will be created for each execution. It will have the error messages if any while transferring data using BCP utility.

This GBCP interface is tested by single user. So, if you catch any errors please do not hesitate to send in to me. It will help the utility to be more robust.

Download GBCP

(This file name is given as GBCP.pdf. But, you have to rename it to GBCP.exe after download)

Please write few lines about this utility in the comment section. Your new ideas are most welcome. Thanks.

Categories: Tools Tags: , ,

Database Image Viewer – SQL Server Utility Software

April 2, 2014 1 comment

This is a SQL Server database utility software used to browse data in the table. This software has two simple screens one for SQL Server authentication and database object selection. The second screen is to browse table data. It is not like typical table browser application. But, if a table contains images then this software will display it along with the other columns.

Screenshots of the ImageViewer software

1)  Authentication and Database object selection screen

pic1

This window contains three sections

1. Provide SQL Server Authentication

2. Connect to Database server

3. Select database and table. Finally click browse button.

2) This is the data viewing screen

pic2We got three buttons in this window

1. Back -> go back to the home screen

2. Load Data – > This action will load the data in the grid

3. Close – > Close the application.

 

You can download this software here  –  BrowseImagesInDB.

After download is completed. We have to rename this application file extension with EXE instead PDF.

Thanks. Please write your comments below.

Categories: Tools Tags: ,

Merging files using 7-zip

February 20, 2014 Leave a comment

In the previous blog post, I talked about the splitting huge file into small file chunks. In this blog post, we are going to learn on how to merge those files in to the original source.

Available files:

pic1Now, we need to execute the following command to extract and merge these files.

7z e -y “SplitMyData.7z.001”

e = Extract

-y = switch to apply yes to all questions asked by the utility. In this example, it is yes to overwrite the file.

“SplitMyData.7z.001” is the first file in the split sequence. 7 zip will automatically combine the next files in serial order to generate source file.

pic2

We got the source file.

pic3

Please read more about the 7 zip software here.

Categories: Tools Tags: , ,

Split a file into multiple files using 7-zip utility

February 19, 2014 1 comment

We may need to compress a huge file to reduce its actual size for storage or transmitting to remote locations. Sometimes, even the compressed file may look large than we expected. So, we may wish to split the huge file into multiple reasonable small chunks for storage or transfer.

There are various compression software available now-a-days. But I am going to use an open source software.

In my example, I am going to split a 484MB file into multiple files of size 128MB.

Step 1: My file

pic1

Step 2: Executing the following command

7z  a SplitMyData -mx0 -v125m MyData.txt

Color coded texts are the 7 zip’s arguments

a = Archive

-mx0 = No compression

-v125m = split size 125 MB

SplitMyData is the file name for file splitting

MyData.txt is the source file

After this command is executed we will get the output as shown below.

pic1So, now we got the files of size we want and it is very simple to do so. This will be really helpful to transfer large file in the slow network.

In the next blog post, I will talk about merging these files into original file.

Full list of 7-zips arguments is given below:

pic2

Thanks for reading.

Categories: Tools Tags: , ,
%d bloggers like this: