Converter SQL database from 2008 to 2005

Posted on 2011-10-05
Medium Priority
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 60

Accepted Solution

Kevin Cross earned 2000 total points
ID: 36917348
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

ID: 37011062
Used Import export function of sql to export thedata using scripts

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Loops Section Overview
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

850 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