NovoRoi Systems DokuWiki

User Tools

Site Tools

Trace:
novo_motion_schema_editor

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
Last revision Both sides next revision
novo_motion_schema_editor [2021/02/03 22:19]
dlm 		novo_motion_schema_editor [2021/02/05 21:19]
dlm
Line 1: Line 1:
 +[[main_page|NovoMotion Outbound Menu]]
  
 ====== NovoMotion Schema Editor ====== ====== NovoMotion Schema Editor ======
Line 11: Line 12:
  
  
-{{:file:novo_schema1.jpg|}}+{{:file:novoschema1.jpg|}}
  
  
Line 87: Line 88:
  
  
-{{:novoschema2.jpg?400|}} +{{:file:novo_schema2.jpg|}}
  
  
Line 105: Line 106:
  
  
- +{{:file:novoschema3.jpg|}}
-{{:novoschema3.jpg?800|}}+
  
  
Line 128: Line 128:
  
  
-==== NovoMotion Schema Editor - Post Job Options tab - SA Map example ====+==== NovoMotion Schema Editor - Post Job Options Tab - SA Map Example ====
  
  
  
-{{file_novo_schema4.jpg}} +{{:novoschema4.jpg|}}
  
  
Line 152: Line 152:
  
  
-The function contains the following drop down menus:+==== NovoMotion Schema Editor - Drop Down Menus ====
  
  
-  * **File**+=== File === 
 +  
  
  
Line 175: Line 177:
  
  
-  * **Edit**+=== Edit === 
  
  
Line 185: Line 188:
  
  
-  * **Tools**+=== Tools ===
  
  
Line 198: Line 201:
  
  
-**Note:**  The Generate SQL Script is used when one wants to generate script to create the SQL table (See the Creating a SQL script information) to avoid the necessity of creating the SQL table by hand.  This is often used multiple times during the development of new schema to perfect the information between U2 and SQL.+Note:  The Generate SQL Script is used when one wants to generate script to create the SQL table (see [[creating_a_sql_script|Creating a SQL Script]]) to avoid the necessity of creating the SQL table by hand.  This is often used multiple times during the development of new schema to perfect the information between U2 and SQL.
  
  
-The SQL script can be pasted into SQL Management Studio and executed. It will drop any existing SQL table of the name defined in the schema and re-create it with the columns defined in the schema. It does this for both the base SQL table and - if an @ACTION row exists - for the parallel SQL trigger table.  See the [[sql_server_management_studio_example]] if you would like to review notes about the SQL Server tasks. +The SQL script can be pasted into SQL Management Studio and executed. It will drop any existing SQL table of the name defined in the schema and re-create it with the columns defined in the schema. It does this for both the base SQL table and - if an @ACTION row exists - for the parallel SQL trigger table.  See the [[sql_server_management_studio_example|SQL Server Management Studio Example]] if you would like to review notes about the SQL Server tasks. 
  
 +If a SQL table has already been established and the schema needs to change, the user has the following options:
 +  - Generate the SQL script through the Schema Editor, copy it, paste it into SQL Management Studio, and execute the script.  This will drop the existing table  and replace the existing SQL column definitions.  Then use [[load_bci.action|LOAD.BCI.ACTION]]  to reload the data into the SQL table.
 +  - Change, add, or delete the desired information in the schema via the Schema Editor, then make the same changes to the SQL table via SQL tools.  Next use [[load_bci.action|LOAD.BCI.ACTION]]  to reload the data into the SQL table.  This can be used when the SQL table has data that cannot be regenerated from the U2 server because the data has already been purged from that server or because the table is large and the data being added is new.
  
-**Additional Usage Notes:**  If a SQL table has already been established and the schema needs to change, the user has the following options: 
-  - Generate the SQL script through the Schema Editor, copy it, paste it into SQL Management Studio, and execute the script.  This will drop the existing table  and replace the existing SQL column definitions.  Then use [[load_bci.action]]  to reload the data into the SQL table. 
-  - Change, add, or delete the desired information in the schema via the Schema Editor, then make the same changes to the SQL table via SQL tools.  Next use [[load_bci.action]] to reload the data into the SQL table.  This can be used when the SQL table has data that cannot be regenerated from the U2 server because the data has already been purged from that server or because the table is large and the data being added is new. 
  
- +=== Help ===
-  * **Help**+
  
  
Line 216: Line 218:
  
  
- +\\ 
 +[[main_page|NovoMotion Outbound  Menu]]
novo_motion_schema_editor.txt · Last modified: 2021/06/08 14:16 by mah

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki
DokuWiki Appliance - Powered by TurnKey Linux