21308 Posts in 5737 Topics by 2603 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 642 Views |
-
SQL Migration Documentation
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 -
Re: SQL Migration Documentation
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
| 642 Views | ||
|
Page:
1
|
Go to Top |
