Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2009

    Unanswered: Running scripts on ACT! and SAGE accounts databases

    Hi All,

    Forgive me if this is a daft question but I have been asked to work on a problem in ACT! and SAGE 50 accounts with little experence in either.

    Anyway, what I want: I have a SAGE 50 Accounts database and an ACT! database that have been set up completely independantly of each other. However there is a products list that is common to both dbs, and this requires updating on a regular basis and currently requires double data entry - i.e. it is manually updated in SAGE and then manually updated in ACT! afterwards.

    What I want is to have some sort of system that runs a script overnight that will update the ACT! database with the information in the SAGE db. I imagine some sort of admin program (e.g. would TOAD do this?) that sits on the server which talks to both dbs and runs the required script.

    Is this feasible and what is the best application for the job (considering price as well as TOAD is fairly expensive!)

    Thanks in advance for any help... It's much appreciated!
    Last edited by cob98tp; 12-08-09 at 08:47.

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 12
    You've posted this in the Microsoft SQL Server topic, so I'm going to suggest SSIS
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts