SQLite to MS SQL – Import Script Using Linked Server

-

This post continues the previous article about connecting SQLite to SQL Server using an ODBC driver and a Linked Server.

The script below retrieves table metadata from the SQLite linked server into a table variable and prepares a cursor over the table names. This can be used as a base for further automation or dynamic import logic.

Retrieve Table Metadata


declare @temp table
(
    col1 varchar(255),
    col2 varchar(255),
    [name] varchar(255),
    [type] varchar(255),
    col3 varchar(255)
)

insert @temp exec sp_tables_ex 'Your_LinkedServer_Name'
select * from @temp

Create a Cursor Over Table Names


DECLARE lstTables CURSOR FOR
select [name] from @temp

Important Notes

  • The Linked Server must already be configured using the MSDASQL provider.
  • The ODBC DSN must be created as a System DSN, not a User DSN.
  • Make sure the DSN name matches the one used when creating the Linked Server.
  • Do not use spaces in the DSN name to avoid query issues in SQL Server.

Summary

This script extracts table information from a SQLite linked server and prepares it for iterative processing. It serves as a foundation for building automated migration or synchronization routines between SQLite and SQL Server.

Comments

Post a Comment

Popular posts from this blog

Configuring IIS to Allow CORS Requests (Fixing AJAX Calls to an API)

-
Image
The problem: sending AJAX requests from an HTML5 application running on my local machine to an API hosted under IIS (Google Cloud). The Setup Client: HTML/JS app on local machine Server: API under IIS (Google Cloud) The request looked like this: $.post({ url: apiEndpoint + "Init", contentType: "application/json; charset=utf-8", data: data, success: function (response) { logResponse("API response [Init]", response.d); }, error: function (xhr, status, error) { logResponse('Fail to call init API', data); } }); The error looked like this: Originally, there was crossDomain: true in the AJAX request, but it didn’t help. There were also crossdomain.xml and clientaccesspolicy.xml on the server — also useless for this case. What I Tried (And Why It Didn’t Help) I found many client-side “solutions” for AJAX, but they did not solve the issue....
Read more

AWS API Gateway + Lambda: How to Add a “Get By ID” Resource (Path Parameter)

-
Image
This thing is not trivial and I couldn’t find a simple explanation. Here is the exact sequence to add a Get By ID -style path parameter like /users/{userid} in API Gateway and wire it to Lambda. Goal Turn an existing resource like /users into: /users /users/{userid} (new resource) Step-by-step Select an existing resource (e.g. users ). Click Actions and select Create Resource . In Resource Name , put the parameter name in curly braces (e.g. {userid} ). In Resource Path , you should see read-only text like /users/ and a textbox for the parameter. Enter {userid} in the textbox and click Create Resource . You should now see a new branch in your API tree: /{userid} . Select it. Click Actions → Create Method and add ANY (or the specific method you need). ...
Read more