Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

getting error ERROR sqlite: Failed to open sqlite file #1580

Open
mangeshongit opened this issue Apr 29, 2024 · 0 comments
Open

getting error ERROR sqlite: Failed to open sqlite file #1580

mangeshongit opened this issue Apr 29, 2024 · 0 comments

Comments

@mangeshongit
Copy link

Is it possible migrate mssql onprem database to postgresql database with below scenario:-

suppose we have table name "employee_name" in source database can we migrate that table into "employee_ID" into the target database ?

Tried simple scenario, but that is giving below error.
+++++++++++++++++++++++++++++++
cat migrate_sample_table.load
LOAD DATABASE
FROM mssql://dbuser:dbuserpassword@mssqldatabasehost:2023/sourcedbname
INTO postgresql://dbuser:dbuserpassword@postgresqldatabasehost:3306/targetdbname
WITH include drop, create tables
;
++++++++++++++
root@ubuntuserver:# pgloader --debug migrate_sample_table.load
pgloader version 3.6.3devel
compiled with SBCL 2.1.11.debian
sb-impl::default-external-format :UTF-8
tmpdir: #P"/tmp/pgloader/"
2024-04-29T12:16:40.004000Z NOTICE Starting pgloader, log system is ready.
2024-04-29T12:16:40.024000Z INFO Starting monitor
2024-04-29T12:16:40.032000Z LOG pgloader version "3.6.3
devel"
2024-04-29T12:16:40.044000Z INFO Parsed command:
LOAD DATABASE
FROM mssql://dbuser:dbuserpassword@mssqldatabasehost:2023/sourcedbname
INTO postgresql://dbuser:dbuserpassword@postgresqldatabasehost:3306/targetdbname
--LOAD TABLE tt3
--FROM dbo.tt3
--INTO tt3_migrated
WITH include drop, create tables
;

2024-04-29T12:16:40.096000Z DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://dbuser@postgresqldatabasehost:3306/targetdbname {1007F80A83}>
2024-04-29T12:16:40.096000Z DEBUG SET client_encoding TO 'utf8'
2024-04-29T12:16:40.096000Z DEBUG SET application_name TO 'pgloader'
2024-04-29T12:16:40.116000Z LOG Migrating from #<SQLITE-CONNECTION sqlite:///home/mangesh/test/mssql:/dbuser:dbuserpassword@mssqldatabasehost:2023/sourcedbname.load {1007F7EE83}>
2024-04-29T12:16:40.116000Z LOG Migrating into #<PGSQL-CONNECTION pgsql://dbuser@postgresqldatabasehost:3306/targetdbname {1007F80A83}>
2024-04-29T12:16:40.132000Z ERROR sqlite: Failed to open sqlite file #P"/home/mangesh/test/mssql:/dbuser:dbuserpassword@mssqldatabasehost:2023/sourcedbname.load": Could not open sqlite3 database /home/mangesh/test/mssql:/dbuser:dbuserpassword@mssqldatabasehost:2023/sourcedbname.load
Code CANTOPEN: no message.
2024-04-29T12:16:40.132000Z LOG report summary reset
table name errors read imported bytes total time read write


        fetch          0          0          0                     0.000s

fetch meta data 0 0 0 0.000s



2024-04-29T12:16:40.172001Z INFO Stopping monitor
+++++++++++

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant