For ERWIN gurus

Question

Post reply

For ERWIN gurus

Dinesh Asanka

SSChampion

Points: 11058
More actions
November 6, 2004 at 7:59 am

#182619

This question is for the ERWIN gurus,
I created an ER diagram from the ERWIN and generate sql script for the SQL Server. but suprisingly I got following two errors.
1. For identity fileds it generates IDentity(1) not Identity(1,1)
2. For the fileds it does not have two square brackets ( [] ) which will generates error when there are key words in the field names.
As these are basic premitive error i think it is not a an error in ERWIN( I hope).
What I may have done. how can i correct it.
Thank You very much.

My Blog: http://dineshasanka.spaces.live.com/

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

bledu SSChampion Points: 12335 More actions · Answer 1

1. For identity fileds it generates IDentity(1) not Identity(1,1)

---

on erwin on the identity field put the input as 1,1 instead of 1.this should solve your problem

****************

2. For the fileds it does not have two square brackets ( [] ) which will generates error when there are key words in the field names.

--------------

i'd suggest that you don't use key words.why give yourself problems you can prevent

**********************

As these are basic premitive error i think it is not a an error in ERWIN( I hope).

What I may have done. how can i correct it.

---

i think that should solve your problem

***************

Thank You very much.

-------------

you are welcome

Everything you can imagine is real.

Dinesh Asanka SSChampion Points: 11058 More actions · Answer 2

thankx, blessing

First one is now ok.

But second one is a problem,as these databases are out of my control which are already created.

My Blog: http://dineshasanka.spaces.live.com/

bledu SSChampion Points: 12335 More actions · Answer 3

the only solution that is there for you if the tables have already been created and you are using complete compare is to actually go into the script when you reach the export changes stage and put the square brackets on the key names.but this route is quite labourious

Everything you can imagine is real.

bbdpres SSCommitted Points: 1876 More actions · Answer 4

Dinesh,

In your forward-engineer options, you need to check the option to use Quote Names. You can find it in the 'Other Options' group of options.

-ldb

bledu SSChampion Points: 12335 More actions · Answer 5

thanks bbdpress i didn't know about that one.

What about when you are using complete compare, how do you set it up?

Everything you can imagine is real.

Robert Stewart Hall of Fame Points: 3399 More actions · Answer 6

You can only use complete compare if you have access to the source databases. The "Quote Names" option will take care of most of the problems that you was running up against.