Versions Compared

Key

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

...

4 - Execute the script below to import the database

Code Block
languagesql
BULK INSERT [ database_name . [ schema_name ] . | schema_name . ] .[ip2location_db3]
    FROM 'FILE-PATH-TO\IP2LOCATION-LITE-DB3.CSV'
    WITH
    (
        FORMATFILE = 'FILE-PATH-TO\DB3.FMT'
    )
GO

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