Create table

CREATE DATABASE ip2proxy
GO

USE ip2proxy
GO

CREATE TABLE [ip2proxy].[dbo].[ip2proxy_px4](
	[ip_from] bigint NOT NULL,
	[ip_to] bigint NOT NULL,
	[proxy_type] nvarchar(3) NOT NULL,
	[country_code] nvarchar(2) NOT NULL,
	[country_name] nvarchar(64) NOT NULL,
	[region_name] nvarchar(128) NOT NULL,
	[city_name] nvarchar(128) NOT NULL,
	[isp] nvarchar(256) NOT NULL,
) ON [PRIMARY]
GO

CREATE CLUSTERED INDEX [ip_to] ON [ip2proxy].[dbo].[ip2proxy_px4]([ip_from], [ip_to]) ON [PRIMARY]
GO

Import the database

BULK INSERT [ip2location].[dbo].[ip2proxy_px4]
    FROM 'C:\[path to your CSV file]\IP2PROXY-IP-PROXYTYPE-COUNTRY-REGION-CITY-ISP.CSV'
    WITH
    (
        FORMATFILE = 'C:\[path to your PX4.FMT file]\PX4.FMT'
    )
GO

PX4.FMT

NOTE: You will need to copy the FMT code below and save it as a file named DB1.FMT on your computer. The first line of the FMT code indicates the version of bcp. Please change the version as according to your MS-SQL installed.

10.0
9
1 SQLCHAR 0 1 "\"" 0 first_double_quote  Latin1_General_CI_AI
2 SQLCHAR 0 20 "\",\"" 1 ip_from ""
3 SQLCHAR 0 20 "\",\"" 2 ip_to ""
4 SQLCHAR 0 3 "\",\"" 3 proxy_type Latin1_General_CI_AI
5 SQLCHAR 0 2 "\",\"" 4 country_code Latin1_General_CI_AI
6 SQLCHAR 0 64 "\",\"" 5 country_name Latin1_General_CI_AI
7 SQLCHAR 0 128 "\",\"" 6 region_name Latin1_General_CI_AI
8 SQLCHAR 0 128 "\",\"" 7 city_name Latin1_General_CI_AI
9 SQLCHAR 0 256 "\"\n" 8 isp Latin1_General_CI_AI

Create table

CREATE DATABASE ip2proxy WITH ENCODING 'UTF8';
\c ip2proxy
CREATE TABLE ip2proxy_px4(
	ip_from integer(10) NOT NULL,
	ip_to integer(10) NOT NULL,
	proxy_type character varying(3) NOT NULL,
	country_code character(2) NOT NULL,
	country_name character varying(64) NOT NULL,
	region_name character varying(128) NOT NULL,
	city_name character varying(128) NOT NULL,
	isp character varying(256) NOT NULL,
	CONSTRAINT ip2proxy_px4_pkey PRIMARY KEY (ip_from, ip_to)
);

Import the database

COPY ip2proxy_px4 FROM 'IP2PROXY-IP-PROXYTYPE-COUNTRY-REGION-CITY-ISP.CSV' WITH CSV QUOTE AS '"';