Documentation 5.0

Release Information

Introduction

Getting Started

Delphix Engine System Administration

Virtual Database Management with the Delphix Engine

Data Backup and Recovery

Delphix Modernization Engine

Delphix Masking

Virtualizing Unstructured Files in the Delphix Engine

Virtualizing Oracle E-Business Suite in the Delphix Engine

JetStream

Mission Control

Delphix Express User Guide

Reference

Documentation for Previous Versions of the Delphix Engine

Delphix Server 3.0 Documentation
Delphix Server 3.1 Documentation
Delphix Engine 3.2 Documentation
Delphix Engine 4.0 Documentation
Delphix Engine 4.1 Documentation
Delphix Engine 4.2 Documentation
Delphix Engine 4.3 Documentation

Skip to end of metadata
Go to start of metadata

Prerequisites

A dSource can only be attached to a new data source once it has been unlinked.

When attaching a SQL Server dSource to a new data source, the new data source must be the same database satisfying the following containts:

  • Same database name
  • Same recovery fork UUID
  • pptRepository needs to be set to the name of the SQL instance on the staging server. The unlink operation removes the database from the SQL instance on the staging server and unmounts the iscsi luns, reattaching the dSource via the CLI will remount the iscsi luns and puts the database back.

Procedure

1. Select the dSource.

delphix> database "dexample"

2. Run the detachSourcecommand, specifying the currently active source. This step can be skipped if the dSource has already been detached through the GUI.

delphix database "dexample"> detachSource
delphix database "dexample" detachSource *> set source=dexample
delphix database "dexample" detachSource *> commit

3. Run the attachSourcecommand.

delphix database "dexample"> attachSource

4. Set the following for SQL Server:

You can also type help pptRepository to see what is wanted 
You can also set pptRepository=<then press tab> to list all values.

delphix database "dexample" attachSource *> set source.config=SQLSERVER/dexample
delphix database "dexample" attachSource *> set source.sharedBackupLocation=\\SERVER1\Backups
delphix database "dexample" attachSource *> set pptRepository=SQL2008R2
delphix database "dexample" attachSource *> set dbUser=dbuser
delphix database "dexample" attachSource *> set dbCredentials.password=dbuserpwd
delphix database "dexample" attachSource *> edit source.operations.preSync
delphix database "dexample" attachSource source.operations.preSync *> back
delphix database "dexample" attachSource *> edit source.operations.postSync
delphix database "dexample" attachSource source.operations.postSync *> back

5. Commit the operation.

delphix database "dexample" attachSource *> commit


 


 

 

  • No labels