Topic
  • 1 reply
  • Latest Post - ‏2013-09-03T10:44:49Z by VolkerFriedrich
karpovmq
karpovmq
7 Posts

Pinned topic How to Change Connect Direct Database to an existing Database?

‏2013-09-02T17:06:56Z |

Hi,

We are using Sterling Connect Direct 4.6.0.1 on a Windows Server 2008 cluster environment. Due to an error, we are using in one server one database (SQL Server 2008) and another database in the other server, we discovered that in the Windows registers (because we don't know ho to see that parameters while Connect Direct is running ). How do we change the database name without recreating the tables? and, is it possible to make this change without restarting the Connect Direct service? Is it just like a pointer?

Thanks a lot for your help!

J.

 

  • VolkerFriedrich
    VolkerFriedrich
    178 Posts
    ACCEPTED ANSWER

    Re: How to Change Connect Direct Database to an existing Database?

    ‏2013-09-03T10:44:49Z  

    This setup will not work and cannot fail-over properly. All servers all need to point to the same single database.

    Stop the Sterling Connect Direct service and run the CD Database Wizard to re-configure the database. You may need to run the wizard on each cluster node, just to be sure the configuration will be the same.
    Existing tables will be preserved, but there is no way to merge your two databases into one.

    Instructions for installing in a cluster can be found in Connect:Direct for Microsoft Windows 4.4 Cluster Service white paper available from the Sterling Connect:Direct for Microsoft Windows Documentation page. Don't mind the version 4.4 in the title.

  • VolkerFriedrich
    VolkerFriedrich
    178 Posts

    Re: How to Change Connect Direct Database to an existing Database?

    ‏2013-09-03T10:44:49Z  

    This setup will not work and cannot fail-over properly. All servers all need to point to the same single database.

    Stop the Sterling Connect Direct service and run the CD Database Wizard to re-configure the database. You may need to run the wizard on each cluster node, just to be sure the configuration will be the same.
    Existing tables will be preserved, but there is no way to merge your two databases into one.

    Instructions for installing in a cluster can be found in Connect:Direct for Microsoft Windows 4.4 Cluster Service white paper available from the Sterling Connect:Direct for Microsoft Windows Documentation page. Don't mind the version 4.4 in the title.