Geek asks and answers

Can I store any user tables in a SharePoint system database?

Can I store user tables in my own SharePoint database?
Is this behavior supported or not?

(I mean the tables in the MS SQL database, not the SharePoint lists.)

If I can, how well does this work with backup / restore features ?
What is possible reservations ?

For someone, I wonder why I ask: there is an application that is bound to a SharePoint server and should store some purely relational internal information that does not make sense except for this instance of SharePoint. I would like to narrow the data warehouse in one place, but I'm not sure that SharePoint likes it when its database is used for other purposes.

I am using SharePoint 2007.

+3
source share
3 answers

Is it possible? Of course. You should? No.

SharePoint content / configuration databases can be modified with any Microsoft updates, and any changes you make are very likely to be destroyed, and if your farm depends on them, they will remain non-functional.

, . SQL Server, / SharePoint, .

+5

It is even worse the higher. Future updates are likely to notice your changes to the content database schema and refuse to update the database period.

+1
source

More articles:


All Articles