26
Jan 08
Tonight I decided to update my site to the Graffiti CMS Beta 2 bits (from the Beta 1 bits). It took exactly one hour to update the site, from the time the thought crossed my mind to being completely done.
Rather than leave unneeded files lying about, I decided to do a clean install. I also decided to keep running the site with Access as my database rather than convert it to VistaDB or move it to SQL Server.
The steps I followed were:
- Downloaded my graffiti.mdb file locally
- Downloaded the contents of my files/media folder, which contained the images I had uploaded to insert into posts.
- Downloaded my site theme, which I had tweaked on the live site and no longer had a current local version. I did this by using the Share option on the theme on the admin screen.
- Downloaded the Beta 2 bits from GraffitCMS.com.
- Extracted the Beta 2 bits onto my local machine.
- Copied the graffiti.mdb that came with Beta 2 from \Graffiti\Data\Utility\Migrations to \Graffiti\Web\App_Data.
- Ran the \Graffiti\Data\Utility\Migrations\DataMover.exe utility against my downloaded graffiti.mdb file, with a destination of \Graffiti\Web\App_Data\graffiti.mdb.
- Copied the downloaded files\media folder contents into \Graffiti\Web\files\media.
- Fired up Graffiti locally, went into the admin screen, and under Site Options - Utilities I ran Rebuild Pages.
- Deleted all folders and directories on my live website.
- Uploaded the entire \Graffiti\Web folder, subfolders, and files up to my live website.
And it all just worked!
Did VistaDB is better than sql server. If not how to migrate to SQL server.
Graffiti comes with a "Data Mover" tool to migrate from one database backend to another. A little more information can be found here: http://graffiticms.com/blog/beta-2-database-changes/. FWIW, I'm actually using Access, not VistaDB or SQL Server, and that works fine for me.