Book a Demo

Author Topic: Import Database issue - SQL Server2014  (Read 4924 times)

Evaluation user

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Import Database issue - SQL Server2014
« on: September 18, 2015, 08:18:23 pm »
Importing an existing SQL server database into Enterprise architect is not working.
I tried using code engineering->db import->select dsn->db->import-> select tables. But after that nothing is happening.
any idea?

thx

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Import Database issue - SQL Server2014
« Reply #1 on: September 18, 2015, 09:12:23 pm »
Which EA version. What SQL Server?

q.

Evaluation user

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: Import Database issue - SQL Server2014
« Reply #2 on: September 18, 2015, 09:39:04 pm »
EA Version 12 (evaluation copy)
SQL Server: Microsoft SQL Server 2014 - 12.0.2000.8 (X64)

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Import Database issue - SQL Server2014
« Reply #3 on: September 19, 2015, 06:39:53 am »
I'm not sure whether that version of SQL server is supported. Have you checked this?

You might use an ODBC connection instead of a native driver.

q.
« Last Edit: September 19, 2015, 06:40:33 am by qwerty »

Evaluation user

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: Import Database issue - SQL Server2014
« Reply #4 on: September 21, 2015, 02:06:26 pm »
I'm using an odbc connection only. Anyway I will check whether EA supports SQL server 2014.

thx

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Import Database issue - SQL Server2014
« Reply #5 on: September 22, 2015, 03:25:31 pm »
Also you better connect using the 32 bit ODBC and not the 64 bit one.
And make suse you have all the required rights. (best try with database admin to rule out any security issues)

Geert