search

sethreno / schemazen

Script and create SQL Server objects quickly
MIT License
333 stars 140 forks source link

I can use schemaZen with a Local Compact Database? #35

Open ghost opened 9 years ago

ghost commented 9 years ago

Hi, I want to get the script of a Local 4.0 Compact SQL database but I dont know If schemazen might be able to achieve this, It would be great. Thanks.

keith-hall commented 9 years ago

Hi @KarloDev, I have done some investigation and the answer is that no, currently SchemaZen doesn't support SQL CE. Accessing a compact SQL database requires the use of a separate assembly, System.Data.SqlServerCe.dll. This assembly is installed separately from the .NET framework, and exists in a Program Files subfolder, Microsoft SQL Server Compact Edition\v3.5\Private. I have tried referencing this, but get an error. I wonder whether it might end up being too much hassle for end-users to get it working...

sethreno commented 8 years ago

I agree with @keith-hall on this, I wouldn't want to add a dependency on SqlServerCe.dll. However, I would be okay if an attempt were made to locate the dll and load it dynamically when scripting a SQL CE database. I'll mark this as up for grabs in case someone is interested in implementing it.