Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Anthony Candaele 1197 posts 2049 karma points
    Feb 07, 2011 @ 21:20
    Anthony Candaele
    0

    incompatible versions of slq server

    Hi,

    I am developing an Umbraco website on my local machine. The version of SQL Server is SQL Server Express 2008 R2. My customer however has SQL Server 2005 installed on his production server, so I won't be able to attach the .mdf and .ldf files of my local machine to SQL Server 2005 on the production server.

    Has anyone faced the same problem? And most important, how did you solve it??

    Thanks for the advice,

    Anthony Candaele
    Belgium

    Copy Link
  • Chris Houston 535 posts 980 karma points MVP admin c-trib
    Feb 07, 2011 @ 21:24
    Chris Houston
    1

    Hi Anthony,

    Yes, it's a regular issue.

    There are two ways we have previously got around this:

    1) Install a copy of SQL 2005 ( that way you are sure it will work )

    2) The way we get around this usually though is to use the "generate script" function and make sure to "include data" and to set the script compatiblity to SQL 2005

    Best regards,

    Chris

    Copy Link
  • Anthony Candaele 1197 posts 2049 karma points
    Feb 07, 2011 @ 21:29
    Anthony Candaele
    0

    Hi Chris,

    Thanks for the advice, I'll try the "generate script" solution and let you know if it succeeded.

    Anthony

    Copy Link
  • Anthony Candaele 1197 posts 2049 karma points
    Feb 07, 2011 @ 22:09
    Anthony Candaele
    0

    Chris, you made my day ... again. Database succesfully installed on production server.

    Thanks a lot for the tip.

    Anthony

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft