Book a Demo

Author Topic: DatabaseBuilder and SQL Server  (Read 4480 times)

Helmut Ortmann

  • EA User
  • **
  • Posts: 970
  • Karma: +42/-1
    • View Profile
DatabaseBuilder and SQL Server
« on: February 27, 2016, 10:16:04 am »
Hi,

I created two tables in EA for SQL Server.

With DataBase Builder I compared them with existing database and generated script, executed script. I found the tables as expected.

Then I tried to compare once more EA tables with database tables. No database tables found by Database Builder.

Generating with Database Builder of the tables failed because they were existing (correct).

But why doesn't find the compare database with EA the tables?

Thanks for any advice!

Helmut
Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: DatabaseBuilder and SQL Server
« Reply #1 on: February 27, 2016, 07:46:17 pm »
Sounds like "get some sleep and a coffee the next day"  ;D

q.

Helmut Ortmann

  • EA User
  • **
  • Posts: 970
  • Karma: +42/-1
    • View Profile
Re: DatabaseBuilder and SQL Server
« Reply #2 on: February 27, 2016, 09:01:12 pm »
Hi,

I think you are right!

It was the missing owner / Schema of SQL Server.

Helmut

Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)