Newbie Newbie Newbie
Stupidly - I have developed a site on a 2008 server only to find out that this should be deployed on a 2005 server.
I have read and actioned various articles and tutorials online - but the all fail (example)
The original file which was sent to me was an sql file, and this was uploaded to a 2008 server and developed. Then it was exported as a .BAK file - which cannot be restored to a 2008 server.
Next I tried the 'Create Scripts' command from SMSS 2008 and got a sql file - I followed the article above (and others) but still get errors.
The syntax looks the same as original sql file which was sent to me:
/****** Object: ForeignKey [FK_cmsContentType_umbracoNode] Script Date: 12/04/2009 08:53:15 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_cmsContentType_umbracoNode]') AND parent_object_id = OBJECT_ID(N'[dbo].[cmsContentType]'))
ALTER TABLE [dbo].[cmsContentType] DROP CONSTRAINT [FK_cmsContentType_umbracoNode]
But I akways get an error.
Is there any other options for me?
On each server it has been a different name and username for access - could that be the problem?