Skip to main content
R
RickTX
Known Participant
October 6, 2010
Question

SQL Server Upgrade

  • October 6, 2010
  • 2 replies
  • 674 views

I have a CF MX 7 application running on a SQL Server 2005 da

tratabase.  Am I going to run with any issues If I upgrade database to SQL Server 2008?

    This topic has been closed for replies.

    2 replies

    C
    carl type3
    Legend
    October 6, 2010

    Probably not CF related but make sure you do a SQL backup (BAK) first and perhaps restore the BAK to another test database to know you can recover.

    Cheers, Carl.

    Owainnorth
    Owainnorth
    Inspiring
    October 6, 2010

    Ah, da tratabase hey?

    No, that'll be fine. CF just has a DSN type of "SQL Server" - it doesn't care what version it is.

    But as with any upgrade do it in a development environment first.

    R
    RickTXAuthor
    Known Participant
    October 6, 2010

    Thanks

    C
    chrisramaro
    Participant
    October 6, 2010

    My company has encountered this numerous times. We've only had to make minor changes to cfc's in a dev environment when upgrading from SQL2K to SQL2K5 to SQL2K8. Shouldn't be an issue, always read the notes on differences/changes to actual SQL language and any stored procedures, etc.

    And always, always, always test your upgrade before committing to production!!!

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices