• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 290
  • Last Modified:

Converter SQL database from 2008 to 2005

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)


0
MSSC_support
Asked:
MSSC_support
1 Solution
 
Kevin CrossChief Technology OfficerCommented:
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).
0
 
MSSC_supportAuthor Commented:
Used Import export function of sql to export thedata using scripts
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now