Home Forums SQL Server 2005 SQL Server 2005 General Discussion What are the differences in data types are there between SQL 2005 and SQL 2008 R2? RE: What are the differences in data types are there between SQL 2005 and SQL 2008 R2?

  • July 10, 2015 at 4:00 pm

    #1811778

    Alvin Ramard (7/8/2015)

    I doubt there's data type changes that would make it hard to move this to SQL2008.

    I agree with Sean. I'd focus on getting as much of the logic out of Access and onto SQL Server. I'd then focus on getting Access out of the picture.

    +1 , I've seen this situation in a past company I worked for where Access had the logic at the client instead of calling stored procedures. The amount of data was not big by any standard yet the amount of slowness and hiccups where disproportionate to what I normally see.

    ----------------------------------------------------