• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

SQL server and Numera Track-IT

B

blarg

Limp Gawd
Joined
Jul 19, 2009
Messages
140
Right now I have SQL server 2000 with a few databases running on it. One of them is for Numera Track-IT 8.5. I need to upgrade to version 9 but the support guy told me I can't use SQL 2000 I have to use SQL basic 2005 or upgrade to SQL server 08.

I never touch SQL aside from letting programs create a database if they need to. So am I going to loose out on anything if I just use the free basic SQL?
 
Last edited:
SQL Express is a limited version, has a max DB size, along with some other limitations. If none of them will impact you, use it. If you can use sql 2008 express go ahead and make that jump
 
Funny that you mention this. Tomorrow I have to review our TrackIT database and see what needs done to migrate it from SQL 2000 on one server to 2008 on another, in preparation for an upgrade to v9.0. SQL Express limits the DB size so we are unable to go that route. Check how big your current DB is and your plans for growth. I always add a little extra to the space requirements when converting to a newer SQL version as well.
 
4gb is the cap on sql express databases both in 2005 and 2008. I would look to whoever manages the licensing and see if you paid for software assurance on your sql 2000 cal. If you paid for for the software assurance and have kept it up, it's pretty much a free upgrade. I'm thinking since Track-IT is making you upgrade they should have some documentation on how to migrate from 2000 to 2005 / 2008. Also if your sql 2000 box has enough resources and isn't terribly old do an inplace upgrade from 2000 to 2005.
 
calvinj's got a good suggestion regarding the CAL.

Assuming you do a database backup from 2000 and restore onto 2005/2008, I cannot think of anything in the Track-IT application that should break from the upgrade. But certainly checkout Track-IT's documentation or contact their support to make sure; you're definitely not the first person to have done such an upgrade, so they should be able to provide some guidance and/or clarifications.
 
You must log in or register to reply here.
Back
Top