MDS Administrator

image_thumb[5]

Connecting

The tool directly connects to the database. Select connect button. Enter the server and choose the database, model, version and click ok.

image_thumb[5]

MDS Schema Compare

Will script changes to deploy on the destination server.

Create missing Entity
Create missing Attribute
Change different Attribute properties.
Create and Rebuild subscription builds.

The compare process uses name and MUID where necessary to realign. It is import to keep the MUID in sync when performing a MDSModelDeploy with includedate flag MDSModelDeploy has a limitation/issue when an attribute is dropped and recreated with the same name but of different type i.e Text -> Domain.

image

The tool will compare the two models and identify

  • Differences between objects
  • Exists on Server A
  • Exists on Server B
  • Same
  • Entity, View and Attribute Renames
  • Provide sql script to update the destination server

Addition Entity and Attribute Compare Features

image

Colour Highlighting

Colour highlighting for:

  • Missing
  • Different
  • Renamed

image

MDS Data Compare
Compare data between models and deploy data changes.

image

Deployment

image

Excel Upload
The name of the sheet is the name of the entity. Each column in excel represents an attribute. You do not have to provide all the columns just the ones you want to work with.

image

image

Excel Template Generation

Step 1 Connect to the Model
Step 2 Choose Tool->Excel Template Gen

image

Choose which server (there may be changes between the models) and select the model,entities and attributes you want to generate.

clip_image001

Last edited Sep 19, 2014 at 6:12 AM by oszymczak, version 16

Comments

No comments yet.