Re: Cloning Production to Dev/Test/Train/Regression

PeterP wrote:
Hi All,

Not sure if I'm after a new feature or just some scripts, surely it's
what us DBA's do.

I'm just wondering the easiest (laziest as I'm busy) way to copy our
production database to say development, training, test etc. once we
upgrade to V11.5.

backup and restore to a different machine?


With all of the new CDR features in V10 upwards, is there some way I
can say - setup database and sync. Then at a later point reconcile
(data or everything) whilst dropping CDR in-between to negate any CDR
risks.
I guess we could go down the HDR path, but then you can run the same
potential problems with networks, transactions. Also we currently use
logged extended datatypes - spatial, web, etx which are always a
headache with spatial clustering etc..

The only thing you run into generally is that you have different user
permissions across different environments (developers different to
production). Also synonyms / views sometimes vary across environments
pointing to different non production sources so you wouldn't always
want the entire schema or user permissions across.

Also, is there a way to rename chunks in a SAN clone operation yet
without dd'ing & patching the reserved pages thus negating the need
for a slow and potentially error prone external rename chunk restore?
This SAN clone option might be quicker then just adjust any views /
synonyms / permissions.

Yes, I know about dbexport/onpload/hpl etc.. just wondering if there
is a really simple easy foolproof fast way with all the new V10
features. Any ideas appreciated.

Its late in OZ, so excuse crap grammer etc..
TIA, Peter.
.

Relevant Pages

  • Re: Oh.... Im just wondering whos seen this stumper...
    ... he was explicit write permissions. ... Joe Richards Microsoft MVP Windows Server Directory Services ... This is done in a testing domain that sort of mirrors production. ...
    (microsoft.public.windows.server.active_directory)
  • Re: CAS newbie
    ... The production web site is a two server ... If you are impersonating, then you will likely need to implement Kerberos ... Joe Kaplan-MS MVP Directory Services Programming ... code group to give full trust permissions to that dll. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: PAPI in the ports
    ... any performance measuring does or must stress ... performance tests on a production server is not the very best idea. ... But to have a such feature on a production system is ... If I get a problem I can easily debug ...
    (freebsd-performance)
  • Re: Can Exmerge transfer permissions and calendars too?
    ... We're migrating from a third-party mailsystem to Exchange 2003. ... files and import them into the production Exchange server. ... What I'd like to know is if Exmerge can save mailbox permissions and ... will these permissions and linked appointments ...
    (microsoft.public.exchange.admin)
  • Re: A User wants DBO on a production db
    ... only statement permissions would fail if the user has the ... dbo) and data access is only through stored procedures, ... production DBA is to ensure the stability and integrity of the ... prod DBA is at odds with the ad-hoc changes to the production database. ...
    (microsoft.public.sqlserver.security)