x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 134 subscribers
  • Views 173 views
  • Users 0 members are here
Browse Forums
Announcements
268
topics
260
replies
Databases and Operating Systems
758
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
851
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
876
topics
3k
replies
Sage CRM for Sage 300
182
topics
410
replies
ReyC

Doing a test and live conversion in Version 2024 and 2023 PU2 and higher

Posted By

Before the security enhancements in version 2024 and 2023 PU2,  when we do a test conversion to a new Server,  I will load the SQL databases and copy the shared data folders to the new server, install the new Sage, run database activation and do the testing.  When we go live,  I will load a new copy of the SQL databases, update the shared data folders in the new server, run a repair of Sage and do the database activation.

In the new version of Sage, I supposed I will have to delete the VAULT and STORE databases in the new server when we go live so that a new database can be created after I run the repair of Sage? 

  • 0

    Hello Reyc, 

    You should be able to just dbdump/load the data from the test server to the live server.. 

    I don't believe  you are  adding a bunch of new users on the test server?  Am I correct?

    when you install 2024 on the new server, you will initially have to setup the vault and store db's.. but once they are created, you can then do dbdump/load from the test server to the live server.. there is no need to delete the vault and store dbs.. 

    Regards, 

    DCrampton

  • 0 in reply to DCrampton

    Thanks.  In situation where we already have the vault/store databases configured and running in an old server and we need to move the sql server and the shared data files to a new server, what will the process be?   Do we backup the store/vault  databases from old server and load it in the new server and create the VaultOwner SQL user in the new SQL server?

*Community Hub is the new name for Sage City