What would be the recommended way to import data for our document types directly into the umbraco db? (The data we need to import is in another sql instance).
Does anyone have a recommend script or guidelines as to how to achieve this?
Is it risky to bypass the umbraco backend and hit the db directly?
We are interested in doing this as we have hundreds of thousands records and a normal import via the cms site is slow.
Import data directly into umbraco db
What would be the recommended way to import data for our document types directly into the umbraco db? (The data we need to import is in another sql instance).
Does anyone have a recommend script or guidelines as to how to achieve this?
Is it risky to bypass the umbraco backend and hit the db directly?
We are interested in doing this as we have hundreds of thousands records and a normal import via the cms site is slow.
Hi Robert
There 2 ways of doing it:
Use "CMSImport" package - http://our.umbraco.org/projects/developer-tools/cmsimport
Write custom code using ContentService - https://our.umbraco.org/documentation/reference/management/services/contentservice
I would not recommend using sql queries
Thanks.
Alex
Hi Alex - we are already using CMS import but it doesn't work well with hundreds of thousands of records.
I want to use sql queries to import directly into umbraco from another sql db.
Can you recommend what tables to insert the data into and in what order?
What about docTypes, are they the same between databases?
The other sql db (where we have our data) is not an umbraco db but data can be retrieved from there that matches the doc types we have in umbraco db.
I am looking for guidelines on inserting this data straight into the umbraco tables.
Hi Robert,
it is always better to use Umbraco content Service.(Alex's #2)
so you can do testing by inserting 2-3 records initially for testing then insert bulk record if the testing is passed.
also by using custom code, we can log the errors if may occured.
I am using Content service for bulk upload when I used to use umbraco v7.
Thanks
Robert,
Did you import your content from directly from SQL successfully in the end?
Im in the same situation now, 30+ records - CMSImport is painfully slow on my server.
Regards
Can anyone guide me on using the second approach with Content Service, I also want to avoid Scripts
How often do you need to do this import?
Just once to import old content pages and members from an existing website to a newer and separately built version of Umbraco
I'm also looking for a solution as CMSImport does not support V8. Did you ever learn how to import?
CMSImport will support V8 soon
is working on a reply...