Get Started with IP2Proxy PX12 Database

CREATE DATABASE ip2proxy
GO

USE ip2proxy
GO

CREATE TABLE [ip2proxy].[dbo].[ip2proxy_px12](
	[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,
	[domain] nvarchar(128) NOT NULL,
	[usage_type] nvarchar(11) NOT NULL,
	[asn] nvarchar(10) NOT NULL,
	[as] nvarchar(256) NOT NULL,
	[last_seen] int NOT NULL,
	[threat] nvarchar(128) NOT NULL,
	[provider] nvarchar(256) NOT NULL,
	[fraud_score] int NOT NULL
) ON [PRIMARY]
GO

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

CREATE DATABASE ip2proxy WITH ENCODING 'UTF8';
\c ip2proxy
CREATE TABLE ip2proxy_px12(
	ip_from bigint NOT NULL,
	ip_to bigint 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,
	domain character varying(128) NOT NULL,
	usage_type character varying(11) NOT NULL,
	asn character varying(10) NOT NULL,
	"as" VARCHAR(256) NOT NULL,
	last_seen integer NOT NULL,
	threat character varying(128) NOT NULL,
	provider character varying(256) NOT NULL,
	fraud_score integer NOT NULL,
	CONSTRAINT ip2proxy_px12_pkey PRIMARY KEY (ip_from, ip_to)
);

CREATE DATABASE ip2proxy
GO

USE ip2proxy
GO

CREATE TABLE [ip2proxy].[dbo].[ip2proxy_px12](
	[ip_from] char(39) NOT NULL,
	[ip_to] char(39) 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,
	[domain] nvarchar(128) NOT NULL,
	[usage_type] nvarchar(11) NOT NULL,
	[asn] nvarchar(10) NOT NULL,
	[as] nvarchar(256) NOT NULL,
	[last_seen] int NOT NULL,
	[threat] nvarchar(128) NOT NULL,
	[provider] nvarchar(256) NOT NULL,
	[fraud_score] int NOT NULL
) ON [PRIMARY]
GO

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

CREATE DATABASE ip2proxy WITH ENCODING 'UTF8';
\c ip2proxy
CREATE TABLE ip2proxy_px12(
	ip_from decimal(39,0) NOT NULL,
	ip_to decimal(39,0) 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,
	domain character varying(128) NOT NULL,
	usage_type character varying(11) NOT NULL,
	asn character varying(10) NOT NULL,
	"as" VARCHAR(256) NOT NULL,
	last_seen integer NOT NULL,
	threat character varying(128) NOT NULL,
	provider character varying(256) NOT NULL,
	fraud_score integer NOT NULL,
	CONSTRAINT ip2proxy_px12_pkey PRIMARY KEY (ip_from, ip_to)
);

BULK INSERT [ip2proxy].[dbo].[ip2proxy_px12]
	FROM \'C:\\[path to your CSV file]\\IP2PROXY-IP-PROXYTYPE-COUNTRY-REGION-CITY-ISP-DOMAIN-USAGETYPE-ASN-LASTSEEN-THREAT-RESIDENTIAL-PROVIDER-FRAUDSCORE.CSV\'
	WITH
	(
		FORMATFILE = \'C:\\[path to your PX12.FMT file]\\PX12.FMT\'
	)
GO

SQL Server 2017 or later (IPv6) can import without FMT.

NOTE: You will need to copy the FMT code below and save it as a file named PX12.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
17
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 "\",\"" 8 isp Latin1_General_CI_AI
10 SQLCHAR 0 128 "\",\"" 9 domain Latin1_General_CI_AI
11 SQLCHAR 0 11 "\",\"" 10 usage_type Latin1_General_CI_AI
12 SQLCHAR 0 12 "\",\"" 11 asn Latin1_General_CI_AI
13 SQLCHAR 0 13 "\",\"" 12 as Latin1_General_CI_AI
14 SQLCHAR 0 14 "\",\"" 13 last_seen ""
15 SQLCHAR 0 15 "\",\"" 14 threat Latin1_General_CI_AI
16 SQLCHAR 0 16 "\",\"" 15 provider Latin1_General_CI_AI
17 SQLCHAR 0 17 "\"\n" 16 fraud_score ""

COPY ip2proxy_px12' FROM \'IP2PROXY-IP-PROXYTYPE-COUNTRY-REGION-CITY-ISP-DOMAIN-USAGETYPE-ASN-LASTSEEN-THREAT-RESIDENTIAL-PROVIDER-FRAUDSCORE.CSV\' WITH CSV QUOTE AS \'"\';

SELECT TOP 1 [ip_from], [ip_to], [proxy_type], [country_code], [country_name], [region_name], [city_name], [isp], [domain], [usage_type], [asn], [as], [last_seen], [threat], [provider], [fraud_score]FROM [ip2proxy_px12]
WHERE [SEARCH IP NO] >= ip_from AND [SEARCH IP NO] <= ip_to