How can I merge archive databases?

Author Message
SoluzioneUfficio

  • Total Posts : 1
  • Joined: 1/16/2017
  • Status: offline
How can I merge archive databases? Monday, January 16, 2017 8:37 AM (permalink)
Hi,
we have MailArchiver Version 2015 Build 20150218 with SQL-Server and i should merge some archives in one Database:
2017 gen - mar_1.mdf
2017 gen - mar_2.mdf
[..]
2017 gen - mar_505.mdf
2017 gen - mar_506.mdf ( email from 01.01.2017 to 31.03.2017)


The archive "2017 gen - mar_*.mdf" are not connected at the GFI MailArchiver
In the file there are between the 2 and the 50 mails.

Only the "2017 gen - mar_506.mdf" is online and in use.

We should merge "2017 gen - mar_*.mdf"  in "2017 gen - mar_506.mdf"
The archive are full SQL.
How can i do this?
thanx and best regards,
Antonio
 
#1
    ianb

    • Total Posts : 934
    • Status: offline
    Re:How can I merge archive databases? Thursday, January 19, 2017 11:54 AM (permalink)
    The easiest way is to export the data from these databases and import again.
     
    GFI Archiver will automatically determine the date of the emails and place them in the appropriate database.
     
    If you SQL databases are SQL only you can use the tool mentioned here:
    http://manuals.gfi.com/en...n/exportsqlrawdata.htm
     
    Otherwise refer to
    http://manuals.gfi.com/en...sfromarchivestores.htm
     
    Please note that for some type of exports some meta data, such as labels, bcc ownership and folder can be lost. For additional help please contact GFI Support.
    Ian Bugeja
    GFI Software
    Blog-Twitter-YouTube-Facebook
     
    #2
      Online Bookmarks Sharing: Share/Bookmark

      Jump to:

      Current active users

      There are 0 members and 2 guests.

      Icon Legend and Permission

      • New Messages
      • No New Messages
      • Hot Topic w/ New Messages
      • Hot Topic w/o New Messages
      • Locked w/ New Messages
      • Locked w/o New Messages
      • Read Message
      • Post New Thread
      • Reply to message
      • Post New Poll
      • Submit Vote
      • Post reward post
      • Delete my own posts
      • Delete my own threads
      • Rate post

      2000-2017 ASPPlayground.NET Forum Version 3.9