sdo export/import guidelines
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
sdo export/import guidelines

 
Post new topic   Reply to topic    Windows Server Forum Index -> CMS Server
Author Message
devo
Guest
Posted: Tue Oct 18, 2005 4:51 pm    Post subject: sdo export/import guidelines Reply with quote
All-
I was wondering whether anyone has any rough guidelines on the use of
running sdo automated scripts with an MCMS environment.
Basically our setup is (at a high level)

We have a read-only (within the DMZ) and a read-write (behind our
firewalls) web server setup.
They both hit the same sql server (although different databases).
We have an automated sdo program which incremenatally updates the
read-only server so that it is kept up-to-date with any new, ammended
or deleted postings/resources (etc, etc).
This sdo program sits and runs on the read-write web server, the export
occurs on this server. We've then introduced another web server (with
mcms installed on it) which is pointed to the same mcms sql server
database as that which the read-only web server points at. The import
occurs through this web server- once finished the read-only site (which
is available to the world) reflects any new changes.

This sdo export/import program is run every two minutes. Does anyone
think that our setup, or the fact that we're running the sdo
export/import so often could cause any serious issues (locking,
performance etc, etc).
The reason I ask is that we sometimes experience IIS performance issues
on the read-write web server when our sdo program is run.

thanks

devo
Back to top
Stefan [MSFT]
Guest
Posted: Tue Oct 18, 2005 4:51 pm    Post subject: Re: sdo export/import guidelines Reply with quote
Hi Devo,

yes this can cause 404 and 500 server errors.
See here for details:
http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#8F855853-100E-400F-A914-AC3A42C2EAD6

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
----------------------


"devo" <deevoy@gmail.com> wrote in message
news:1129650554.861946.141520@z14g2000cwz.googlegroups.com...
Quote:
All-
I was wondering whether anyone has any rough guidelines on the use of
running sdo automated scripts with an MCMS environment.
Basically our setup is (at a high level)

We have a read-only (within the DMZ) and a read-write (behind our
firewalls) web server setup.
They both hit the same sql server (although different databases).
We have an automated sdo program which incremenatally updates the
read-only server so that it is kept up-to-date with any new, ammended
or deleted postings/resources (etc, etc).
This sdo program sits and runs on the read-write web server, the export
occurs on this server. We've then introduced another web server (with
mcms installed on it) which is pointed to the same mcms sql server
database as that which the read-only web server points at. The import
occurs through this web server- once finished the read-only site (which
is available to the world) reflects any new changes.

This sdo export/import program is run every two minutes. Does anyone
think that our setup, or the fact that we're running the sdo
export/import so often could cause any serious issues (locking,
performance etc, etc).
The reason I ask is that we sometimes experience IIS performance issues
on the read-write web server when our sdo program is run.

thanks

devo
Back to top
Denis Dougall
Guest
Posted: Tue Oct 18, 2005 8:51 pm    Post subject: Re: sdo export/import guidelines Reply with quote
I run MCMS and SQL server and I copy DB's back and forth and have found that
to be a faster approach. I have yet (knock on wood) to encounter a problem.
Am I just lucky or could this be a better way Stefan?

Denis

"Stefan [MSFT]" <stefang@online.microsoft.com> wrote in message
news:%23qqSQ8$0FHA.1256@TK2MSFTNGP09.phx.gbl...
Quote:
Hi Devo,

yes this can cause 404 and 500 server errors.
See here for details:

http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#8F855853-100E-400F-A914-AC3A42C2EAD6

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
----------------------


"devo" <deevoy@gmail.com> wrote in message
news:1129650554.861946.141520@z14g2000cwz.googlegroups.com...
All-
I was wondering whether anyone has any rough guidelines on the use of
running sdo automated scripts with an MCMS environment.
Basically our setup is (at a high level)

We have a read-only (within the DMZ) and a read-write (behind our
firewalls) web server setup.
They both hit the same sql server (although different databases).
We have an automated sdo program which incremenatally updates the
read-only server so that it is kept up-to-date with any new, ammended
or deleted postings/resources (etc, etc).
This sdo program sits and runs on the read-write web server, the export
occurs on this server. We've then introduced another web server (with
mcms installed on it) which is pointed to the same mcms sql server
database as that which the read-only web server points at. The import
occurs through this web server- once finished the read-only site (which
is available to the world) reflects any new changes.

This sdo export/import program is run every two minutes. Does anyone
think that our setup, or the fact that we're running the sdo
export/import so often could cause any serious issues (locking,
performance etc, etc).
The reason I ask is that we sometimes experience IIS performance issues
on the read-write web server when our sdo program is run.

thanks

devo


Back to top
Stefan [MSFT]
Guest
Posted: Wed Oct 19, 2005 8:51 am    Post subject: Re: sdo export/import guidelines Reply with quote
Hi Denis,

while copying a database the database is offline and cannot accessed by an
application.

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
----------------------


"Denis Dougall" <Denis.Dougall@moh.gov.on.ca> wrote in message
news:%236KdZlB1FHA.3124@TK2MSFTNGP12.phx.gbl...
Quote:
I run MCMS and SQL server and I copy DB's back and forth and have found
that
to be a faster approach. I have yet (knock on wood) to encounter a
problem.
Am I just lucky or could this be a better way Stefan?

Denis

"Stefan [MSFT]" <stefang@online.microsoft.com> wrote in message
news:%23qqSQ8$0FHA.1256@TK2MSFTNGP09.phx.gbl...
Hi Devo,

yes this can cause 404 and 500 server errors.
See here for details:

http://download.microsoft.com/download/4/2/5/4250f79a-c3a1-4003-9272-2404e92bb76a/MCMS+2002+-+(complete)+FAQ.htm#8F855853-100E-400F-A914-AC3A42C2EAD6

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
----------------------


"devo" <deevoy@gmail.com> wrote in message
news:1129650554.861946.141520@z14g2000cwz.googlegroups.com...
All-
I was wondering whether anyone has any rough guidelines on the use of
running sdo automated scripts with an MCMS environment.
Basically our setup is (at a high level)

We have a read-only (within the DMZ) and a read-write (behind our
firewalls) web server setup.
They both hit the same sql server (although different databases).
We have an automated sdo program which incremenatally updates the
read-only server so that it is kept up-to-date with any new, ammended
or deleted postings/resources (etc, etc).
This sdo program sits and runs on the read-write web server, the export
occurs on this server. We've then introduced another web server (with
mcms installed on it) which is pointed to the same mcms sql server
database as that which the read-only web server points at. The import
occurs through this web server- once finished the read-only site (which
is available to the world) reflects any new changes.

This sdo export/import program is run every two minutes. Does anyone
think that our setup, or the fact that we're running the sdo
export/import so often could cause any serious issues (locking,
performance etc, etc).
The reason I ask is that we sometimes experience IIS performance issues
on the read-write web server when our sdo program is run.

thanks

devo




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