Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
moo

Veteran
Registered:
Posts: 184
Reply with quote  #1 

Hi I am looking at the solution tables in V9 and think it will be really good if we can move away from having to create our tables in management studio.

However, when I am ticking the 'Index' checkbox, it appears to be ignoring this completely. I am checking this by going into Management Studio and generating the sql to create the table and there is no mention of the Index at all.

I was doing this to check if the index was clustered or not, hopefully it would be.

If someone could provide me the answers, that would be much appreciated :-)

Thanks

0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #2 
It always works for me. Indexes are non clustered. Frankly clustered indexes by default would cause far more problems than not.

The alternative is just to create your own using SQL. The maintenance cost is not high, and the options are far greater . You do need to create additional documentation etc, if you want to do it properly.

__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
suityou01

Avatar / Picture

Veteran
Registered:
Posts: 213
Reply with quote  #3 
A word of caution. If you create the table in the Designer, then any further modifications should be done in the designer also.

Consider this scenario.

You create a table, let's call it "Orders", and have a few basic columns :

ORDER_ID, ORDER_NO, ORDER_DATE, ORDER_AMOUNT.

You publish the process, the table is created and starts to fill up with data.

During the course of the lifetime of the process you add some more columns to the table through Management Studio, lets say VAT_AMOUNT for example.

Then lets say you bulk populate this column to bring it up to date.

The next time you deploy your process, the column will get dropped.

Also bear in mind when you deploy a process with a solution table, if you drop the table the next time you deploy the table will be recreated.

Also note that the deployment drops the PK and recreates each time so for particularly large tables this can be time consuming.
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #4 
I do not believe the column will be dropped if there s data in it, or even if there is data in the table.

My main reason for using scripts (NOT management studio, ever) to maintain tables is to give us more control. The Designer limits you to one PK and one index, which is often not enough.

In more recent cases, I have resorted to keeping a separate solution with Tables in, as I have had many problems with speed and warnings when deploying to Oracle. We only deploy the table silution when it changes, so it also gives us a record or what changes and when.

__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
moo

Veteran
Registered:
Posts: 184
Reply with quote  #5 
Hi, thanks for your replies, much appreciated.

I can confirm that, if you create a solution table within the V9 Designer, publish, then make changes to the table in Management Studio (add a new column), and then republish the solution, the new column remains in the table in Management Studio. However the solution table within the designer remains as it was originally, so without the additional column.
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #6 
No, the Designer does not pick up fields you have added yourself. This has always been the case.

In most cases, I advise either creating tables manually or with the Designer, never both. I all cases, if tables are maintained manually, do it using a script, not the database tools. That way you can move changes to different environments with less chance of errors.

__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!