Create Table

CREATE DATABASE ip2proxy
GO

USE ip2proxy
GO

CREATE TABLE [ip2proxy].[dbo].[ip2proxy_px9](
	[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] int(10) NOT NULL,
	[as] nvarchar(256) NOT NULL,
	[last_seen] int NOT NULL,
	[threat] nvarchar(128) NOT NULL,
) ON [PRIMARY]
GO

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

Import Database

BULK INSERT [ip2proxy].[dbo].[ip2proxy_px9]
	FROM 'C:\PATH_TO_YOUR_CSV_FILE\IP-PROXYTYPE-COUNTRY-REGION-CITY-ISP-DOMAIN-USAGETYPE-ASN-LASTSEEN-THREAT.CSV'
	WITH
	(
		FORMATFILE = 'C:\PATH_TO_YOUR_PX9.FMT_FILE\PX9.FMT'
	)
GO

PX9.FMT

10.0
15
1	SQLCHAR	0	1	""	1	first_double_quote	Latin1_General_CI_AI
2	SQLCHAR	0	20	""	2	ip_from			""
3	SQLCHAR	0	20	""	3	ip_to			""
4 	SQLCHAR	0	3	""	4	proxy_type		Latin1_General_CI_AI
5 	SQLCHAR	0	2	""	5	country_code		Latin1_General_CI_AI
6 	SQLCHAR	0	64	""	6	country_name		Latin1_General_CI_AI
7 	SQLCHAR	0	128	""	7	region_name		Latin1_General_CI_AI
8 	SQLCHAR	0	128	""	8	city_name		Latin1_General_CI_AI
9 	SQLCHAR	0	256	""	9	isp			Latin1_General_CI_AI
10 	SQLCHAR	0	128	""	10	domain			Latin1_General_CI_AI
11 	SQLCHAR	0	11	""	11	usage_type		Latin1_General_CI_AI
12 	SQLCHAR	0	10	""	12	asn			""
13 	SQLCHAR	0	256	""	13	as			Latin1_General_CI_AI
14 	SQLCHAR	0	10	""	14	last_seen		""
15 	SQLCHAR	0	128	""	15	threat			Latin1_General_CI_AI

Create Table

CREATE DATABASE ip2proxy WITH ENCODING 'UTF8';
\c ip2proxy
CREATE TABLE ip2proxy_px9(
	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 integer(10) NOT NULL,
	as character varying(256) NOT NULL,
	last_seen integer(10) NOT NULL,
	threat character varying(128) NOT NULL,
	CONSTRAINT ip2proxy_px9_pkey PRIMARY KEY (ip_from, ip_to)
);

Import Database

COPY ip2proxy_pxpx9 FROM 'IP-PROXYTYPE-COUNTRY-REGION-CITY-ISP-DOMAIN-USAGETYPE-ASN-LASTSEEN-THREAT.CSV' WITH CSV QUOTE AS '"';