Merge two db3 files sqlitestudio1/14/2024 ![]() Other platforms (SQL server) might not have this problem, however we do not feel the need to change our setup, since ODBC connection works like a charm in our environment (with SAS software creating the dataset and PowerBi reporting it). Where DB.db is the database file, and db.sql is the SQL file to run/import. The only downside: the user needs to be logged in on the Machine with the Gateway for the ODBC refresh to work. Alternatively, you can do this from a Windows commandline prompt/batch file: sqlite3.exe DB.db '.read db.sql'. This is working stable in our organization for a couple of years now. Make sure this machine is powered ON and the same user who used the ODBC connection is logged on and the PowerBi Service can refresh your data via the gateway. I am guessing that you are trying to use the sqlite3 command line tool that you can dowload from the website. Install a gateway on the same machine who has the ODBC connection. read code.sql command, or call sqlite3 with the file as input: sqlite3 a.db3 < code.sql. This even works in the PowerBi service: Publish the report in the service. ![]() Then you can connect to a SQL lite Db in PowerBi Desktop via the ODBC connection on your machine. Originally Answered: how can I use sqlite3 to merge two sqlite databases with each other Connect to database A Attach database B (ATTACH 'c:databasebplaces. You need to install the ODBC driver on you machine.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |