Export and Import of Databases
Hi all,
We are currently running two RDM servers for the same team (historical it has been DE and UK separated).
Now I want to create a RDM databases which contains the information of both RDMs and consolidate it afterwards.
We have backup'd both databases and tried to restore it into a new database. This doesn't work as expected as we are having the following issues.
EMail from a database-team colleague
"
1. Load the two databases, rename the first to GRP_IS_ESO_Server
2. Import Attachment to GRP_IS_ESO_Server from secondary database
successful
3. Import ConnectionGroup
pass 1. identity column
pass 2. identity_insert off; ForeignKey constraint "FK_ConnectionGroup_ConnectionID"
pass 3. removed foreign key, import works. Will not re-apply foreign key
Msg 547, Level 16, State 0, Line 4
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_ConnectionGroup_ConnectionID". The conflict occurred in database "GRP_IS_ESO_Server", table "dbo.Connections", column 'ID'.
Msg 4917, Level 16, State 0, Line 9
Constraint 'FK_ConnectionGroup_ConnectionID' does not exist.
Msg 4916, Level 16, State 0, Line 9
Could not enable or disable the constraint. See previous errors.
"
Is there anything we are doing wrong?
Cheers,
Dom
All Comments (1)
Hello,
You cannot use such techniques to handle a RDM database. You must use our import export capabilities to merge your two systems. Our versioning system does make use of timestamps, therefore everything becomes skewed whenever you use Data Transformation Services or other wizards of this type to migrate data.
There's a big caveat with our import/export capabilities though. Sadly, our documents/attachments are NOT exported, well only partially. We export the entry, but not the document itself when you have chosen to store it in the database.
With the current release, your only option is to go through each document, then use the Save as feature to store it back on your disk. You will have to recreate the entry in the destination data source. Sorry about that extra work.
In RDM 12, the new Powershell Module as been designed from the start to support not only the documents, but also all of the management aspects of a RDM installation.
Best regards,
Maurice