+11
Hi
we have staging environemnt -used to test the product on the client environment - and production environment -GO live-.
We have two sql databases for each environment
What are the implicationsof changing the SQL Databse for k2 server in staging and production environments.
i hope this question is clear.
+14
Basically, create backups of the db’s. Restore the db’s to the new environment. You can also run the configuration manager afterwards.
http://www.k2underground.com/forums/thread/28483.aspx
K2 db backup best practices
vernon
+11
Yes in a way or another
i want to backup the staging database then restore it on the production and vice versa. this is dependent on our march in the project.
+14
Steps to remember:
1) Stop the K2 Server
2) Bd’s do backup: K2Categories, K2Dependencies, K2EnvorinmentSettings, K2EventBus, K2EventBusScheduler, K2HostServer, K2ServerLog, K2SmartLog, K2SmartBox, K2SQLUM, K2WebDesigner, K2WebWorkflow, K2WorkSpace
3) Restore db’s to new server
4) Re-run the configuration manager.
Recourses that might be helpful: How to transfer logins and passwords between instances: http://support.microsoft.com/kb/246133
Important SQL considerations: http://msdn.microsoft.com/en-us/library/ms190436.aspx
HTH
Vernon
+11
So in the end; if i have a staging environment i can change it to production just by changing the database. Is that true?
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.