Visokio website     Downloads     Video tutorials     KnowledgeBase  
Database output drop table - Visokio Forums
Database output drop table
  •     Mees February 16, 2012 10:06AM
    We are updating data in tables on an external database using the Database output in DM.
    As the table is dropped and rebuilt by omniscope, all fieldsettings and indexes are changed or completely removed.
    This is causing the system running on these tables, to crash completely.

    We basically need a solution that just updates or adds records in an existing table without changing any structures.

    Is anything like this possible?

    Thanks
  • 1 Comment
  •     steve February 16, 2012 12:14PM
    Sure. You need to check the "Publish method" tab of "Database output". I think you want "Replace row data". Requires 2.7.
Add a Comment

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories