Converter SQL database from 2008 to 2005

Posted on 2011-10-05
Last Modified: 2012-06-27
Hi All,
I am trying to convert a SQL server database to go from a test bed site to our live environment however the versions are not compatible. I have tried to generate a script but keep receiving an error even as an SA user at the same location:

Property TextHeader is not available for StoredProcedure '[ACOCMP1].[add_hiredest]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.  The text is encrypted. (Microsoft.SqlServer.Smo)

Question by:MSSC_support
    LVL 59

    Accepted Solution

    Unfortunately, you cannot run a SQL 2008 database on SQL 2005 instances. You can go the other way, but cannot come back even if the compatibility level was set to 90 (SQL 2005).

    Author Closing Comment

    Used Import export function of sql to export thedata using scripts

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now