Save Project

ApexSQL Clean project files (.axcl) are XML files that store all options and settings relevant to a particular project.

You can save a project either by clicking the or the button.

When you click the button, the Save Project As dialog appears:

Enter a filename and click . If a project with the same name as you have entered already exists, ApexSQL Clean issues a warning:

If you confirm the warning, the existing project file will be overwritten. Alternatively choose and enter a different name for the project.

Below you can see an example of an ApexSQL Clean project file. All of our applications project files are XML files. You may edit the project file in any capable editor and then open it again in the ApexSQL Clean GUI or use it in CLI mode.

<Project Version="2005.7.122.0" Application="ApexSQL Clean" StoreEncryptedPassword="False" Server="PC\SQL2005" TrustedConnection="True" Login="" Database="TestAudit" Password="">

  <OptionsProfile>

    <CommentProfile>

      <Comments count="0" ExcludeComments="True" />

    </CommentProfile>

    <SearchProfile>

      <SearchSettings WholeWord="True" IgnoreTriggers="False" CaseSensitive="False" />

    </SearchProfile>

    <SelectionProfile CatalogType="StructureCatalog">

  <OptionGroup>

    <Option id="Datatype" Analysable="1" AllSelected="1" />

    <Option id="Default" Analysable="1" AllSelected="1" />

    <Option id="Partition Function" Analysable="1" AllSelected="1" />

    <Option id="Partition Scheme" Analysable="1" AllSelected="1" />

...

      <Patterns DbObjectType="Partition Scheme" />

      <Patterns DbObjectType="Queue" />

      <Patterns DbObjectType="Remote Service Binding" />

      <Patterns DbObjectType="Route" />

      <Patterns DbObjectType="Service" />

      <Patterns DbObjectType="Synonym" />

      <Patterns DbObjectType="Xml Schema Collection" />

    </PatternsByTypes>

    <FileSelection DirRecursive="False">

      <Folders />

      <Patterns DbObjectType="Table" />

    </FileSelection>

    <Databases>

      <Database>pubs</Database>

    </Databases>

    <ObjectsForDrop>

      <SelectionProfile CatalogType="StructureCatalog">

  <OptionGroup>

...

    <Option id="Route" Analysable="1" AllSelected="0" />

    <Option id="Service" Analysable="1" AllSelected="0" />

    <Option id="Synonym" Analysable="1" AllSelected="0" />

    <Option id="Xml Schema Collection" Analysable="1" AllSelected="0" />

  </OptionGroup>

  <ObjectsSelection Type="Datatype" />

  <ObjectsSelection Type="Default" />

  <ObjectsSelection Type="Function">

    <object Name="AUDIT_fn_HexToStr" Owner="dbo" />

    <object Name="AUDIT_fn_SqlVariantToString" Owner="dbo" />

  </ObjectsSelection>

  <ObjectsSelection Type="Procedure">

    <object Name="AUDIT_prc_AddAuditUndoItem" Owner="dbo" />

    <object Name="AUDIT_prc_AggregateReport" Owner="dbo" />

    <object Name="AUDIT_prc_UndoGenerateCommand" Owner="dbo" />

...

  <ObjectsSelection Type="Synonym" />

  <ObjectsSelection Type="Xml Schema Collection" />

</SelectionProfile>

    </FilterForViewerShow>

  </OptionsProfile>

</Project>

Copyright © 2007 ApexSQL LLC. All Rights Reserved.