Search code examples
gosql-server-ce

GoLang and opening MS SQL Compact files (.sdf)


As the title suggests, I'm attempting to open an SDF/MSSQL CE database in GoLang. Is this possible?

The GoLang Libraries I've found do not appear to suppot MSSQL CE database connections.

I hope this is not a duplicate, but I can not find info online


Solution

  • I'm afraid it would hardly be possible to work with these files directly as they merely are on-disk storage format, and note that MSSQL DBs of all flavors use .sdf as the extension of the file names of their DBs, so by itself they mean nothing.

    OTOH, one direct way to approach this problem would be using OLE DB layer.