|
Home > Archive > Microsoft Content Management Server > August 2005 > Deployment with SDO or Database Restore?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Deployment with SDO or Database Restore?
|
|
| Alfredo 2005-08-09, 5: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
| |
| Stefan [MSFT] 2005-08-09, 5: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
>
| |
| Alfredo 2005-08-09, 5: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
| |
|
| 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
| |
| Stefan [MSFT] 2005-08-10, 2: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
>
| |
| Alfredo 2005-08-10, 8:48 pm |
| 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
| |
| Stefan [MSFT] 2005-08-11, 2: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
>
|
|
|
|
|