SQLite To MS SQL (continuation)

SQLite To MS SQL (continuation)

So there is an evolution of this process - SQL script that import SQLite linked DB to MS SQL DB:

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

And also open a cursor:

DECLARE lstTables CURSOR FOR 
        select [name] from @temp

Comments