CLI Cookbook: V2P virtual to physical on SQL server

This topic describes how to export a physical single instance SQL Server database from a VDB using the Delphix Engine command-line interface.

Prerequisites

You will need the following information:

The VDB name which you wish to export.
The database name of the SQL Server database you wish to create
The layout of the filesystems on the target server where data should be exported.
The target repository in which to create the physical database. Repositories can be listed with the /repository list command.

Procedure

Execute the command database export .
ActionScript
```
delphix> database export
```

Specify the set type=MSSqlExportParameters

ActionScript

delphix database export *> set type=MSSqlExportParameters

Set the VDB you wish to export

ActionScript

delphix database export *> edit timeflowPointParameters
delphix database export timeflowPointParameters *> set container=vdb
delphix database export timeflowPointParameters *> back

Edit the sourceConfig configuration, specifying the parameters for the database created via V2P.

delphix database export *> edit sourceConfig
delphix database export sourceConfig *> set type=MSSqlSIConfig
delphix database export sourceConfig *> set databaseName=v2p_db
delphix database export sourceConfig *> set repository=win2012/SQL2016
delphix database export sourceConfig *> back

Set the destination locations.

delphix database export *> edit filesystemLayout
delphix database export filesystemLayout *> set targetDirectory=C:\temp
delphix database export filesystemLayout *> set archiveDirectory=archive 
delphix database export filesystemLayout *> set dataDirectory=datafiles 
delphix database export filesystemLayout *> set externalDirectory=external 
delphix database export filesystemLayout *> set scriptDirectory=script 
delphix database export filesystemLayout *> set tempDirectory=temp

Commit the configuration to execute the job.
ActionScript
```
delphix database export *> commit
```