dimitri / pgloader

Migrate to PostgreSQL in a single command!
http://pgloader.io
Other
5.46k stars 548 forks source link

Failing to do basic data import - Command file syntax error #846

Closed tonysepia closed 6 years ago

tonysepia commented 6 years ago
load database
        from mssql://user@192.168.0.0/DBNAME
        into postgresql://localhost/dbname
KABOOM!
FATAL error: At

        from mssql://sa@192.168.0.0/DBNAME
        into postgresql://localhost/dbname

                                   ^ (Line 3, Column 33, Position 82)

In context COMMAND:

While parsing COMMAND. Expected:

     the character Tab
  or the character Newline
  or the character Return
  or the character Space
  or the string "--"
  or the string "/*"
  or the character ; (SEMICOLON)
  or the string "after"
  or the string "alter"
  or the string "before"
  or the string "cast"
  or the string "excluding"
  or the string "including"
  or the string "set"
  or the string "with"
An unhandled error condition has been signalled: At

        from mssql://sa@192.168.0.0/DBNAME
        into postgresql://localhost/dbname

                                   ^ (Line 3, Column 33, Position 82)

In context COMMAND:

While parsing COMMAND. Expected:

     the character Tab
  or the character Newline
  or the character Return
  or the character Space
  or the string "--"
  or the string "/*"
  or the character ; (SEMICOLON)
  or the string "after"
  or the string "alter"
  or the string "before"
  or the string "cast"
  or the string "excluding"
  or the string "including"
  or the string "set"
  or the string "with"

What I am doing here?

At

        from mssql://sa@192.168.30.10/RUK
        into postgresql://localhost/gkar

                                   ^ (Line 3, Column 33, Position 82)

In context COMMAND:

While parsing COMMAND. Expected:

     the character Tab
  or the character Newline
  or the character Return
  or the character Space
  or the string "--"
  or the string "/*"
  or the character ; (SEMICOLON)
  or the string "after"
  or the string "alter"
  or the string "before"
  or the string "cast"
  or the string "excluding"
  or the string "including"
  or the string "set"
  or the string "with"
dimitri commented 6 years ago

It looks like you're missing the command ending semicolon character (;).

tonysepia commented 6 years ago

Thank you, this has advanced me in formulating the basic Command file.