sqldb_create_script.sql': Invalid filename

[swalde]

on page 20 in "GS1 Resolver - Overview and Architecture.pdf" command: /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P its@SECR3T! -i /gs1resolver_sql_scripts/sqldb_create_script.sql does not work Error: Sqlcmd: '/gs1resolver_sql_scripts/sqldb_create_script.sql': Invalid filename.

[swalde]

/opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P its@SECR3T! -i /resolver_sql_server/sqldb_create_script.sql

does not work either

[swaldegs1]

Goes for me to

[swaldegs1]

Problem solved using SSMS from the hosting Labtop having SQL Server Management Studio SSMS installed on hosting Window 11 box, then run this command, using SSMS sqlcmd: sqlcmd -S localhost -U 'sa' -P 'its@SECR3T!' -i .\resolver_sql_server\sqldb_create_script.sql

[ablears]

The problem is /gs1resolver_sql_scripts/sqldb_create_script.sql is not a valid path when inside the SQL server container.

So do something like this from the project root: docker cp resolver_sql_server/sqldb_create_script.sql YOURSQLCONTAINERID://sqldb_create_script.sql docker exec -it resolver-sql-server bash /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P its@SECR3T! -i /sqldb_create_script.sql

[abiriadev]

So do something like this from the project root: docker cp resolver_sql_server/sqldb_create_script.sql YOURSQLCONTAINERID://sqldb_create_script.sql docker exec -it resolver-sql-server bash /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P its@SECR3T! -i /sqldb_create_script.sql

It would be really helpful if it is documented somewhere.

[abiriadev]

I made a PR for this issue: #66