I do the export like this:
- select source archive
- select "Export Data" tab, then Table tab
- add manually created tables
- each table added with these options: create timestamp (uncheck), modified timestamp (uncheck), create new table or field ... (checked), replicate deleted rows (checked)
On preview view of exported tables, I can see the data that I want to be migrated. After all, I choose Export action to export archive.
But, when use ftp (or scp) to copy that source archive to destination content server file system, I create a new destination archive from that copied one.
I open the copied archive and cannot found data row that exported from source archive, so that I cannot receive row on schema after import on destination content server.
What is my mistake?
thank in advance
Edited by: Cuong Pham on Oct 31, 2012 6:40 PM
You can't use FTP to copy the archive.
Archives are sent from one instance to another using the "Transfer" option in Archiver. Instances connect through a Provider. It's all well documented and commonly used.
If you really really really REALLY want to just use FTP to manually upload archives, there is a technique that uses SiteStudio Backup archives:
How can I ensure that schema tables data has been exported already?
When doing exporting, I've seen that only Collections table was exported (on progress bar). After that, I read files which was exported on archive, but cannot find any file contain database table's row. Where is the file, and how the row data is stored on exported archive ?
Sorry for many silly question, mister :)
Edited by: Cuong Pham on Nov 1, 2012 10:35 AM
I've set up and transfer archive successfully from source to destination Content Server instance (pull transfer). But the result is not satisfied. The data from manually created tables cannot be bring to destination schemas. I think the problem is that tables had not exported although I added them to export tables list.
If I want create a new table on source schema, insert data to it, add that table to export list, then migrate to destination schema. Can you share some guidances to me ?
Did you finally figure out how to export table/view data from source and import to the target? Could you share?
Ive done this sucessfully many times using Archiver, as you have mentioned.
Only thing is , once you transfer the exported archive to the detsination, you need to udpate the collections.hda with the archive name and desc from the source collections.hda. No need to create another archive at destination.
Once you update that, you will be able to see this archive at the destination Archiver, and will be able to Import the data.