REQUEST A DEMO

Tag: schemaeditor

Dovetail SchemaEditor vs. ddcomp – or – why is ddcomp so slow?

May 2, 2011 While doing some prep for my upcoming webinar on Clarify/Dovetail Schema 101, I started doing some closer looking into what SchemaEditor and ddcomp actually do under the hood.   We’ve had some good reports from customers on how much faster schema changes get applied when using Dovetail SchemaEditor. I knew it as well, but I didn’t really know why. So I put on my Encyclopedia Brown hat and started my investigation. The scenario   My test case was pretty simple: add a new column to the case table. A pretty common scenario. Dovetail SchemaEditor   I ran SchemaEditor, adding a new x_test_integer column. I examined the logs emitted by SchemaEditor, as well as the SQL Profiler trace.   Here are the changes SchemaEditor made to the database:   1. Add the new column to the metadata (adp_sch_info table) INSERT INTO adp_sch_info (…)     VALUES…

Webinar: Clarify / Dovetail Schema 101

April 27, 2011 In this complimentary webinar, I’ll be covering the basics of your Clarify/Dovetail schema. This will be a good overview for those who are new to a Clarify/Dovetail system, and a good refresher for those who have been around for a while. Topics Schema and database concepts Viewing your schema Editing your schema Schema tools A walkthrough of customizing your schema using SchemaScript Assorted tips and tricks for working with your schema When Thursday, May 17, 2011 11:00 AM - 12:00 PM (Central Time) Register Register at:  https://dovetailsoftwareevents.webex.com/dovetailsoftwareevents/onstage/g.php?t=a&d=669385476  Schema 201 Interested in a more advanced session? I’m considering doing a Schema 201 session, including items such as SQL Views, Database Flags, Change Fields, Pseudo Relations, MTM tables, ADP in more detail, etc. If this is something you’re interested in – please let me know! I’ll probably only do this if there’s…

Using UltraEdit’s function list with Dovetail Schema files

January 31, 2011 A question recently came up on how to use UltraEdit to show the list of all of the objects in a Dovetail SchemaEditor Data Dictionary file. A Data Dictionary file is a complete definition of a schema. As I’ve mentioned in the past, I rarely use complete schema files, preferring instead to work with simpler schemascript files. Although I often use UltraEdit for editing text files, I rarely use UltraEdit for editing XML files. I prefer Visual Studio, with its integrated support for XSD, which gives me intellisense and syntax checking. Regardless, I dove into UltraEdit configuration, and with a bit of help from Sam Tyson, I figured out how to make this work. Function List We’ll use UltraEdit’s function list functionality to make this work. In my version (UltraEdit 16), it’s accessed by the menu: View –> Views/Lists –>…
    class='wp-pagenavi' role='navigation'>
  • 1
  • 2