Few months ago, after some big update of Win 10, I started to get annoying notifications: This message appeared randomly without any systematic causes. The system looked like this: I endured this for a long time but finally decided to fix it. And I had a plan to slice small piece from C: and extend E: to this piece. Note: disk D: is removable disk so C: and E: are on same HDD and they siblings :-) So I went to Disk Management to fix this and I saw this thing: E: drive hasn't major actions of another drives include "Extend Volume..." Anyway I sliced 2Gb from my C: drive with "Shrink Volume..." option. I got Additional unallocated space between C: and E: drives. After that I tried many "dances with tamburin around a campfire" - move E: after C:, allocate new space etc. Nothing didn't help. I know that there is limitations of built-in utilities of Windows and I started to search around the Net... All leads told me that I should use

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

This is the working instructions to open SQLite DB in MS SQL or Access Creating a SQL Server Linked Server to SQLite to Import Data The main point is ODBC Driver declaration in System DSN. After this you can link the DB to MS SQL or open it in Access as well. The short list of steps: Install ODBC driver for SQLite ( http://www.ch-werner.de/sqliteodbc/ ) Create a System DSN for the DB file (via C:\Windows\SysWOW64\odbcad32.exe or odbcad64.exe) Create a linked server in SQL Server Just few remarks: Don't use spaces in System DSN name - it will be a problem to work with select queries in MS SQL It also opens as Access DB Despite of possibility to open DB in Access, an import from Access to MS SQL was failed because there are no fields detected during export procedure. It's sad...  For browsing of original file I used the recommended soft  DB Browser for SQLite

This is a first finished and published project today! :-) AliExpress Order Extractor

Company branded page was created today. Take a look! https://www.facebook.com/OxymoronTech

Today I did insertion of blog feed into the company site. That's how it looks: http://oxymoron-tech.oxy.co.il/Blog.aspx