Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Need to move SmarterTrack to another server

Posted on 2015-02-12
8
Medium Priority
?
245 Views
Last Modified: 2015-05-06
Hi there,

I must move a locally hosted SmarterTrack 9.5 to another server.

Also, on the new server, I need to upgrade to the latest version.

Can you please provide me with he instructions?

Thanks
0
Comment
Question by:ReneGe
  • 4
  • 3
8 Comments
 
LVL 13

Expert Comment

by:Rizzle
ID: 40606418
0
 
LVL 10

Author Comment

by:ReneGe
ID: 40606463
Hi Roshan,

Thanks for your prompt reply.

However, in this installation iinstruction, it is not mentionned how to backup and restore the curent system in detail (Database and everything).

Thanks and cheers
0
 
LVL 13

Expert Comment

by:Rizzle
ID: 40606468
How is your database currently hosted? SQL Express or SQL Dedicated standalone?
0
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
LVL 10

Author Comment

by:ReneGe
ID: 40606474
Microsoft SQL Server
0
 
LVL 13

Assisted Solution

by:Rizzle
Rizzle earned 400 total points
ID: 40606485
In your scenario I think it would be more safer to log a call directly with Smarttrack to ensure the database migration is done correctly.
0
 
LVL 41

Accepted Solution

by:
footech earned 1600 total points
ID: 40606577
I don't know how much guidance they would provide for managing databases.

Typically you'll connect with SQL Management Studio, select the SmarterTrack database, right-click and choose Tasks >  Back Up.
On the new server, you'll install SQL, create a new database named SmarterTrack, then right-click on Databases and choose Restore to restore to your newly created database using the file created previously, and selecting the option to replace the database.  I have a note that I had to add “NT Authority/Network Service” as a login, but that might have been because I was using IIS and that's what my App Pool for the SmarterTrack site was using.

Then run the SmarterTrack install and during the configuration choose your existing database and it will be upgraded.
0
 
LVL 10

Author Comment

by:ReneGe
ID: 40606601
Thanks Footech

I'll try that later and let you know if I have any questions.

Cheers
0
 
LVL 10

Author Comment

by:ReneGe
ID: 40762901
Sorry for taking so long to reply.
Thanks for your assistance.
Cheers
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This month, Experts Exchange’s free Course of the Month is focused on CompTIA IT Fundamentals.
Your business may be under attack from a silent enemy that is hard to detect. It works stealthily in the shadows to access and exploit your critical business information, sensitive confidential data and intellectual property, for commercial gain. T…
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Suggested Courses

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question