moving attachments to another DB
Aldevinas Katkus
9-27-19
Is there a simple way to move attachments to another DB without having to renumber attachment records manually?
There is an export in DB Maintenance module "Special company backup" which exports, if I understand it correctly, the current company info on attachments.
What could be the next step to import this file into the another DB with different number of companies?
Omar Dottin
9-27-19
Hello! In a client/server environment, just copy all of the data in the attachment folder on the server and paste into your new environment. The attachments will be brought forward :) Hope this helps!

HW Support
Aldevinas Katkus
9-30-19
Maybe I haven't clear enough: we're moving some companies to other database, for example, company 1 in database A should become company 51 in database B. Database A had many attachments which should be properly reattached in the database B. There is no problem with attachments, as they have unique names in the Attach folder, the problem is with links to these external files.
As far as I understand "Special company backup" exports current company attachment info. That's what I need to import into the database B, how can I do that import into the database B with proper renumbering of links and attachments registers:
e.g., if we had a record number (index) in database A equal to 1 (one), in the database B 1 must become the next available serial number, because 1 is already used in the database B by some something else.
Omar Dottin
12-10-19
Hi Aldevinas!

If you export RLinkVc from Database A (Module Database Maintenance >> Routines >> Register Export), you should be able to change the company number in the first column of the export from 1 to 51 and re-import into Database B.

Please let me know if this helps solve your issue. Thanks!

Best Regards,
Omar
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Back to the list
Latest Posts
David Delač
Hi Piotr, The log entry:
2024-12-14 08:40:43 0.000 CallHal(IsHansaWorldCustomer) appears because the server is running with the verbosity=debug-detailed setting in its parameters.txt file. Thi...
09:43 16 Dec 2024
Brittany McGrath
Hi Vaughn, I can confirm this has been fixed now and is live in Standard ERP 2024-11-20 Version: 85556786. Thank you. ...
10:04 10 Dec 2024