Deployment with SDO or Database Restore?
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > Microsoft Content Management Server > Deployment with SDO or Database Restore?




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    Deployment with SDO or Database Restore?  
Alfredo


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-09-05 10:54 PM

Hi,

I have a question. We have a development enviroment in which we have
develop our solution, with cms templates and asp.net pages and
webservices and components.

I want to know which is the best option to deploy my solution to a
testing enviroment, i mean, other CMS server and other Sql Server.

I think it is enough to do a database restore. What do you think? do i
have to use a sdo file?

Thanks,

Alfredo Barrientos






[ Post a follow-up to this message ]



    Re: Deployment with SDO or Database Restore?  
Stefan [MSFT]


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-09-05 10:54 PM

Hi Alfredo,

if you need to deploy everything SQL backup and restore will be fine.

Cheers,
Stefan

--
This posting is provided "AS IS" with no warranties, and confers no rights

New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
----------------------


"Alfredo" <abarrientos@gmail.com> wrote in message
news:1123616801.743357.5660@g44g2000cwa.googlegroups.com...
> Hi,
>
> I have a question. We have a development enviroment in which we have
> develop our solution, with cms templates and asp.net pages and
> webservices and components.
>
> I want to know which is the best option to deploy my solution to a
> testing enviroment, i mean, other CMS server and other Sql Server.
>
> I think it is enough to do a database restore. What do you think? do i
> have to use a sdo file?
>
> Thanks,
>
> Alfredo Barrientos
>







[ Post a follow-up to this message ]



    Re: Deployment with SDO or Database Restore?  
Alfredo


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-09-05 10:54 PM

Hi Stefan,

Imaging the same scenario, but before deploy my solution, i create a
lot of posting and channels in development enviroment, with real data.

Is it still enough backup and restore my sql server db or it is
necessary sdo file?

Thanks,

Alfredo Barrientos






[ Post a follow-up to this message ]



    Re: Deployment with SDO or Database Restore?  
Shawn


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-10-05 01:49 AM

As Stefan mentions, backing up your SQL database in your
development/authoring environment and restoring it in your production
environment will work fine.  However, all settings in production will
end up being the same as development.  In other words, all
configuration for MCMS is also in the database; by restoring the
backup, you're getting that configuration as well.  If the production
and development environments are not the same, just keep in mind that
you'll have to go through the Server Configuration Application to
change any settings that need to be modified for the new environment.

On a going-forward basis, SDO files will likely be a better option.

Shawn






[ Post a follow-up to this message ]



    Re: Deployment with SDO or Database Restore?  
Stefan [MSFT]


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-10-05 07:49 AM

Hi Alfredo,

these channels and postings are in the database.
So if you copy the database everything is copied.

Cheers,
Stefan

--
This posting is provided "AS IS" with no warranties, and confers no rights

New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
----------------------


"Alfredo" <abarrientos@gmail.com> wrote in message
news:1123621973.777358.223630@g44g2000cwa.googlegroups.com...
> Hi Stefan,
>
> Imaging the same scenario, but before deploy my solution, i create a
> lot of posting and channels in development enviroment, with real data.
>
> Is it still enough backup and restore my sql server db or it is
> necessary sdo file?
>
> Thanks,
>
> Alfredo Barrientos
>







[ Post a follow-up to this message ]



    Re: Deployment with SDO or Database Restore?  
Alfredo


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-11-05 01:48 AM

Hi Stefan. Thanks for answering.

I have additional question, what happens if i have configured security
roles in each channel, are these secutiry settings applied too?

Thanks,

Alfredo Barrientos






[ Post a follow-up to this message ]



    Re: Deployment with SDO or Database Restore?  
Stefan [MSFT]


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-11-05 07:54 AM

Hi Alfredo,

everything is stored in the database. So if you copy the database everything
is on the destination server.

Cheers,
Stefan

--
This posting is provided "AS IS" with no warranties, and confers no rights

New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
----------------------


"Alfredo" <abarrientos@gmail.com> wrote in message
news:1123709879.193969.107140@z14g2000cwz.googlegroups.com...
> Hi Stefan. Thanks for answering.
>
> I have additional question, what happens if i have configured security
> roles in each channel, are these secutiry settings applied too?
>
> Thanks,
>
> Alfredo Barrientos
>







[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 03:32 AM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register