Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Using one DB for 2 completely different apps

Author  Topic 

CoffeeAddict
Yak Posting Veteran

94 Posts

Posted - 2010-03-27 : 00:02:15
I have an existing SQL 2008 DB running my Subtext blog. I want to use the same DB to run my Screwturn wiki. Both are open source and right now the table names are completely unique to both apps.

Any risk in doing this? Is this common to combine a few apps into one DB?

Why would I want to do this? to save money. I don't feel that spending an extra $120 just to house my small wiki that is only for personal use on an entirely different database than the one that runs my Subtext Blog. It's not worth the cost and the app is so small, it makes no sense in doing this.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-27 : 13:09:20
It sounds like you made a great case for combining them. If you ever run into an object name conflict, then consider using different schemas for each so there would be no conflict.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -