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

Filed under:
|

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

Related posts about sql-server

Related posts about sqlite