Show Posts
1
Bugs and Issues / Database Builder synchronize with SQL Server
« on: March 17, 2016, 07:46:44 am »
Hi,
Using EA Corporate 12.1, created SQL Server several databases in EA. When I created the tables, I chose SQL Server 2008 in the Database Dropdown in the Table dialog window.Generated DDLs and created databases and all was well. Then I started using Database Builder to keep my changes in sync with the databases and have noticed several curious behaviors.
1. Varchar columns on the database side (EA side is still correct) have been altered to varchar(1) from varchar(nnn).
2. Sometimes updating comments works, sometimes it doesn't so that every time i go to sync I get hundreds of comments changes.
3. EA diff compare doesn't recognize changes in sizes. I changed a few columns from varchar(64) to varchar(128) but this change doesn't show after trying to synchronize all.
4. I have one table which won't synchronize. Both sides have the primary key set up as a clustered index but EA wants to drop the database side index and rebuild. I removed all foreign key restraints, allowed EA synch (yes, I'm executing the code) to drop and add a new primary clustered key index. Running diff/sync/execute again was clean. As soon as i re-established the foreign keys, EA reported that it needs to do a drop/add of the primary clustered key index it just said was clean.
Very frustrating. Any clues? I'm a little bothered by the fact that the most recent database in the table create database dropdown is SQL Server 2008, yet other dropdowns include SQL server 2012. Not sure if that's an issue or not.
Thanks
TIm
Tim
Using EA Corporate 12.1, created SQL Server several databases in EA. When I created the tables, I chose SQL Server 2008 in the Database Dropdown in the Table dialog window.Generated DDLs and created databases and all was well. Then I started using Database Builder to keep my changes in sync with the databases and have noticed several curious behaviors.
1. Varchar columns on the database side (EA side is still correct) have been altered to varchar(1) from varchar(nnn).
2. Sometimes updating comments works, sometimes it doesn't so that every time i go to sync I get hundreds of comments changes.
3. EA diff compare doesn't recognize changes in sizes. I changed a few columns from varchar(64) to varchar(128) but this change doesn't show after trying to synchronize all.
4. I have one table which won't synchronize. Both sides have the primary key set up as a clustered index but EA wants to drop the database side index and rebuild. I removed all foreign key restraints, allowed EA synch (yes, I'm executing the code) to drop and add a new primary clustered key index. Running diff/sync/execute again was clean. As soon as i re-established the foreign keys, EA reported that it needs to do a drop/add of the primary clustered key index it just said was clean.
Very frustrating. Any clues? I'm a little bothered by the fact that the most recent database in the table create database dropdown is SQL Server 2008, yet other dropdowns include SQL server 2012. Not sure if that's an issue or not.
Thanks
TIm
Tim