Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

General Questions /

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

SQL Migration Documentation


Reply


3 Posts   799 Views

Avatar
Ben Gribaudo

Community Member, 181 Posts

16 April 2009 at 4:11am

Hello,

We have a mid-sized site we'd like to migrate from a home-grown CMS to SS. It might save some effort if we could automate the bulk of this migration. One way to do this would using SQL to insert pages in SS's database. Is there any documentation out there on how to do this (such as "how to create new SS pages via SQL")?

Thanks!
Ben

Avatar
Willr

Forum Moderator, 5513 Posts

16 April 2009 at 8:45pm

To create a page in the cms have alook at the 'SiteTree' and 'SiteTree_Live' tables.

I think you would be able to get it to work by doing something like 'INSERT INTO SiteTree (Title, Content, URLSegment, ParentID....) VALUES ('My Page', 'My Content', 'page-url', 0)

It would involve just a bit of trial and error and playing round :). I think you will be able to just insert into sitetree and then run publish/all rather then insert into 2 tables.

Also another way that might be useful is andy has developed a static importer for one of our clients sites, imports a couple thousand pages from a think a CSV file export of their database. You might like to check out the code for that - http://open.silverstripe.com/browser/modules/staticimporter/trunk

Avatar
Ben Gribaudo

Community Member, 181 Posts

17 April 2009 at 3:18am

Thanks for these pointers, Will!