Book a Demo

Author Topic: How to set SQL Server 2005 as default db type  (Read 2797 times)

webmarco

  • EA Novice
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
How to set SQL Server 2005 as default db type
« on: July 22, 2007, 08:10:05 am »
I know it should be possible through
Settings --> Database Databasetypes --> Product name dropdown, but there is no entry for SQL Server 2005 nor any of the other types reffered to in:

Version 7.0 - Released (Build 813)
.....
Data Modeling now supports four additional DBMS targets:  
    Adaptive Server Enterprise  
    Informix  
    Ingres  
    SQL Server 2005  
....

I ran the full setup for 7.0 (build 814) and let the setup program uninstall 6.5 (build 806)

Marco

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: How to set SQL Server 2005 as default db type
« Reply #1 on: July 22, 2007, 01:11:48 pm »
You'll find the extra datatypes in the EABase.eap and EAExample.eap files.

Open one of these, from tools menu select Export Reference Data | Model Data Types - Cose and DDL.

Then use Import Reference Data to mport the xml file into your model.

webmarco

  • EA Novice
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Re: How to set SQL Server 2005 as default db type
« Reply #2 on: July 23, 2007, 01:20:25 am »
Thank you