Creating user tables in the CMS database
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
Creating user tables in the CMS database

 
Post new topic   Reply to topic    Windows Server Forum Index -> CMS Server
Author Message
Dilip Kumar
Guest





Posted: Sat Jan 08, 2005 9:31 am    Post subject: Creating user tables in the CMS database Reply with quote

For my CMS application, I need to create a few tables in
the database. From the convenience point of view, I'm
thinking of creating those tables in the CMS database.
What is the argument for NOT using the CMS database?
Thanks.

Dilip Kumar
Back to top
Angus Logan [MVP]
Guest





Posted: Sat Jan 08, 2005 2:35 pm    Post subject: Re: Creating user tables in the CMS database Reply with quote

Hi Dilip,

The general rule is:- DON'T EVER TOUCH THE MCMS DATABASE! :)

I say this for a few reasons:-
- If you touch the database (alter it or query it directly) your solution
will not be supported by Microsoft.
- I have heard (never seen) that some product's service packs will detect
objects that are not meant to be in database and remove them

I suggest you create another SQL Database and store your new tables.

Regards
--
________________________________________

Angus Logan (MCAD/MCDBA/MCP/MVP for MCMS)
Product Specialist
Microsoft Application Solutions
Data#3 Limited
E angus_logan@data3.com.au
BLOG www.anguslogan.com
________________________________________
"Dilip Kumar" <anonymous@discussions.microsoft.com> wrote in message
news:0ee001c4f532$966c8200$a301280a@phx.gbl...
Quote:
For my CMS application, I need to create a few tables in
the database. From the convenience point of view, I'm
thinking of creating those tables in the CMS database.
What is the argument for NOT using the CMS database?
Thanks.

Dilip Kumar
Back to top
Stefan [MSFT]
Guest





Posted: Sat Jan 08, 2005 3:50 pm    Post subject: Re: Creating user tables in the CMS database Reply with quote

Hi Dilip,

Angus is completly right!

Cheers,
Stefan.

"Angus Logan [MVP]" <angus_logan@data3.com.au> wrote in message
news:OTwlS0V9EHA.2032@tk2msftngp13.phx.gbl...
Quote:
Hi Dilip,

The general rule is:- DON'T EVER TOUCH THE MCMS DATABASE! :)

I say this for a few reasons:-
- If you touch the database (alter it or query it directly) your solution
will not be supported by Microsoft.
- I have heard (never seen) that some product's service packs will detect
objects that are not meant to be in database and remove them

I suggest you create another SQL Database and store your new tables.

Regards
--
________________________________________

Angus Logan (MCAD/MCDBA/MCP/MVP for MCMS)
Product Specialist
Microsoft Application Solutions
Data#3 Limited
E angus_logan@data3.com.au
BLOG www.anguslogan.com
________________________________________
"Dilip Kumar" <anonymous@discussions.microsoft.com> wrote in message
news:0ee001c4f532$966c8200$a301280a@phx.gbl...
For my CMS application, I need to create a few tables in
the database. From the convenience point of view, I'm
thinking of creating those tables in the CMS database.
What is the argument for NOT using the CMS database?
Thanks.

Dilip Kumar

Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> CMS Server All times are GMT
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB