![]() You can do this by executing the below Python script on your database file. Select the database using the linked service wizard, and provide the SQL authentication credentials.Įxtract the CREATE TABLE statements from your SQLite database. Set the authentication type to Anonymous.Ĭreate another linked service for your Serverless SQL target. db file, and the DSN with the name of the system DSN connection: Connection string: Provider=MSDASQL.1 Persist Security Info=False Mode=ReadWrite Initial Catalog=C:\sqlitemigrationsource.db DSN=sqlitemigrationsource Enter the below into the connection string, replacing the Initial Catalog variable with the filepath for the. Select your integration runtime from the "Connect via integration runtime" dropdown. Give the linked service a meaningful name, for example, sqlite_odbc. Search for and select the "ODBC" connector. In Connections, under Linked Service, select New.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |