I have generated a script from a online database and used the script on a local database and as far as I can see then it works without any problems. But I get these errors (about 50 errors) when I execute the script in SQL Express, see some examples below:
1: There are no primary or candidate keys in the referenced table 'dbo.cmsContentType' that match the referencing column list in the foreign key 'FK_cmsContent_cmsContentType_nodeId'.
2: Constraint 'FK_cmsContentXml_cmsContent_nodeId' does not exist.
3: There are no primary or candidate keys in the referenced table 'dbo.cmsContentType' that match the referencing column list in the foreign key 'FK_cmsPropertyTypeGroup_cmsContentType_nodeId'.
Are these errors normal or does it affect the new local installation?
MS SQL Backup / script
Hi,
I have generated a script from a online database and used the script on a local database and as far as I can see then it works without any problems. But I get these errors (about 50 errors) when I execute the script in SQL Express, see some examples below:
1:
There are no primary or candidate keys in the referenced table 'dbo.cmsContentType' that match the referencing column list in the foreign key 'FK_cmsContent_cmsContentType_nodeId'.
2:
Constraint 'FK_cmsContentXml_cmsContent_nodeId' does not exist.
3:
There are no primary or candidate keys in the referenced table 'dbo.cmsContentType' that match the referencing column list in the foreign key 'FK_cmsPropertyTypeGroup_cmsContentType_nodeId'.
Are these errors normal or does it affect the new local installation?
// René
I think that it is safer to just restore a backup of the online database on your local machine. That way you are sure all constraints are there.
Using a generated script can miss some things.
Dave
Hi Dave,
What's the best procedure to restore a backup to online server? Do you know a tutorial?
Cheers...
Hi Dave
I tried your solution and it worked without any errors.
Thanks!
// René
is working on a reply...