Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
BULK INSERT [dualshield_database_name].[dbo].[ip2location_db3]
    FROM 'FILE-PATH-TO\IP2LOCATION-LITE-DB5.CSV'
    WITH
    (
        FORMATFILE = 'FILE-PATH-TO\DB5.FMT'
    )
GO

...

* replace "FILE-PATH-TO" with the actual file path where the downloaded file is saved, e.g. "c:\downloads"

* For dualshield version < 8.0, the name of the table in the database is called "ip2location_db3", although the import file is called "db5.csv"

...