Issue
Complexity of SQL and which version is compatible
Product Line
TAC INET
Environment
TAC I/NET Seven and congruent Windows Operating System. File Master, Filemaster, EqualizedClient, Compatibility, SQL, SQL 2008, Full SQL, SQL 2005, SQL2008, SQL2005, SQL Express, Express SQL, MSDE, 2.31, 2.40, 2.40a, 2.41, Server, XP, Windows 7, 7, 32-bit, 64-bit, Microsoft SQL, Service Pack, SP
Cause
Filemaster and either Equalized Client or Remote Client is desired. Problem is to know which versions of SQL are compatible.
Resolution
Below is a handy chart designed to help in determining what versions of SQL are compatible in I/NET Seven.
Pertains to MSDE, SQL Express, SQL 2000, 2005, 2008.
Note: 1. Do not mix versions of SQL server among equalized or client/server workstations in your TAC I/NET Seven system. Ensure that the edition of SQL server installed on each workstation used in a client/server or equalized setting are based on the same version of Microsoft SQL, either 2000, 2005, 2008, or 2008
2. It is strongly recommended that you defragment the PC’s hard drives on a regular basis. Severely fragmented hard drives can cause poor system performance and in some cases can introduce data errors.
3. The use of any edition of Microsoft SQL Server 2005, 2008, or 2008 R2 will require that the PC have at least 2 GB of RAM.
4. No Express edition of Microsoft SQL Server can be used on a TAC I/NET Seven filemaster.
Golden Rule: You cannot move the db or downgrade from I/NET db SQL 2008 to I/NET db SQL 2005, see