is it possible to have an sqlite database in a sqlserver field?
Posted
by Behrooz
on Stack Overflow
See other posts from Stack Overflow
or by Behrooz
Published on 2010-03-21T11:49:39Z
Indexed on
2010/03/21
11:51 UTC
Read the original article
Hit count: 421
sql-server
|sqlite
I think my question seems to be vague. I am trying to save user settings in SQLServer, but the problem can be expressed in this term:"it needs 20 tables with circular dependencies. and i have enough tables to fill 3 database diagrams", so the best way encountered to my brain is to save it as a sqlite database in a field, like this:
Index |Name |Data
1 |Behrooz |*sqlite database here*
2 |User1 |*sqlite database here*
...
is this way the right way?is it stupid?
should i create more tables instead of doing all these?
does it increase database fragmention?
© Stack Overflow or respective owner