Instance.Export Method

Creates an XML instance configuration file (ICF) and one or more XML application definition files (ADFs) (one per application) by exporting the metadata from the databases.

Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

public void Export (
	string baseDirectory,
	bool overwriteExistingFiles
public void Export (
	String baseDirectory, 
	boolean overwriteExistingFiles
public function Export (
	baseDirectory : String, 
	overwriteExistingFiles : boolean



A String that specifies the full path of the directory in which to write the files.


true to overwrite files of the same name in the specified directory; otherwise, false.

The resulting files are valid definitions of the instance and applications at the time that you run the export command. You can use this information to back up your instance and application definitions or to generate files that you can use to create or update the instance.

You can export metadata while the Notification Services instance is running. There is no need to disable or stop the instance.

The resulting configuration file is named instance_name.config.xml. Each resulting ADF is named instance_name.application_name.adf.xml.

The Export method exports the files using UTF-8 encoding. To export the configuration and application definition files using other encodings, use the Export command in Microsoft SQL Server Management Studio.

The following examples show how to use this method to export an ICF for an instance of Notification Services:

nsinst.Export(@"C:\NS\Full", true);

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions