Post reply

Downgrade from 2008 to 2005 datetime2 issue

  • November 4, 2010 at 1:38 pm

    #226046

    Hello,

    I have been asked to downgrade a 2k8 server to a 2k5 server. I am trying to use scripts but the scripts fail with:

    ... DateTime2, which is not supported in the target server version, SQL Server 2005. (Microsoft.SqlServer.Smo)

    I set the "Script for Server Version" to 2k5 and the compatibility of the db to 2k5, but of course, none of these things converts datetime2 in the db itself, nor does it account for a cast in the scripts.

    What are my options for this downgrade?

    I have done searches for this problem, but the closest threads seem to end with "you can't restore downwards". But, there has to be a way to modify the scripts, right?

  • November 4, 2010 at 1:46 pm

    #1246824

    Open the scripts in an editor and do a search and replace?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply