Book a Demo

Author Topic: Change a table's database type  (Read 4998 times)

skiwi

  • EA Expert
  • ****
  • Posts: 2081
  • Karma: +46/-82
    • View Profile
Change a table's database type
« on: May 29, 2015, 10:09:53 am »
I reverse engineered a SQL Server 2005 DB (using EA 1213).
I created a new data model for SQL Server 2008.
I created a new database.
I copied a table from the 2005 database to the 2008 database.

How then to change the DB type in my copied table so it matches the Database type?
I can't see any "Advanced" menu item, and the copies table has the Database Type greyed out and unchangeable.
Orthogonality rules
Position and Team disestablished, thanks austerity.
Now itinerant.

Dermot

  • EA Administrator
  • EA User
  • *****
  • Posts: 591
  • Karma: +7/-0
    • View Profile
Re: Change a table's database type
« Reply #1 on: May 29, 2015, 10:33:47 am »
The Table Properties has a drop-down Database in the Main tab.
This is where you can change the DBMS type.

skiwi

  • EA Expert
  • ****
  • Posts: 2081
  • Karma: +46/-82
    • View Profile
Re: Change a table's database type
« Reply #2 on: June 02, 2015, 07:22:32 am »
Thanks, couldn't see it for looking.
But why not allow the DB version to be changed from the Table Detail tab as well, or only have that attribute on one tab, rather than two.
Orthogonality rules
Position and Team disestablished, thanks austerity.
Now itinerant.