Migrating Graffiti from VistaDB to SQL 2008

Lately my Graffiti blog running Vista DB is being having lock problems and slowing down my blog. After sending an email to my website hoster ORCSWeb They replied with a suggestion to upgrade to VistaDB, this is the kind of service they are running. They even gave me the steps to do that. You can read my review about ORCSWeb here.

Steps:
1. Create a new SQL Server database.
2. Install the Graffiti schema (NO sample data)
3. Download your vista db file
4. Run datamover (give it your sql connectionstring and point it at your vista database)
5. Update your web.config

Creating the database and installing the Schema is not a big deal if you got the SQL manager for 2008 install, the application datamover will do the rest for you. Will take a very long time as has copy all the tables, the Post_Statistics may take a hour or more.

After the migration, I changed the connection string to the database and now my Telligent Graffiti 1.2 is extremely fast and ready to take any volume of users.

Website can be found at: http://alpascual.com

Cheers

Al

Published Saturday, May 2, 2009 11:28 AM by albertpascual
Filed under:

Comments

# re: Migrating Graffiti from VistaDB to SQL 2008

Friday, February 15, 2013 2:44 PM by Dailey

Great information. Lucky me I ran across your blog by chance (stumbleupon).

I have saved as a favorite for later!

# re: Migrating Graffiti from VistaDB to SQL 2008

Saturday, February 16, 2013 8:51 PM by Hackney

Hello! I just want to offer you a huge thumbs up for the excellent info you've got right here on this post. I'll be returning to

your blog for more soon.

# re: Migrating Graffiti from VistaDB to SQL 2008

Friday, April 12, 2013 1:25 AM by Casteel

Pretty! This has been an extremely wonderful article.

Thanks for supplying this info.

# re: Migrating Graffiti from VistaDB to SQL 2008

Sunday, April 14, 2013 8:12 PM by Craddock

I drop a comment each time I like a article on a site or if

I have something to valuable to contribute to the discussion.

It's triggered by the sincerness displayed in the post I browsed. And after this article Migrating Graffiti from VistaDB to SQL 2008 - Al Pascual ASP.NET Blog. I was moved enough to drop a thought :-P I do have 2 questions for you if you don't

mind. Is it just me or does it appear like a few of these remarks look like they are coming from brain dead individuals?

:-P And, if you are writing on other social sites, I would

like to keep up with you. Would you list every one of all your public sites like your twitter

feed, Facebook page or linkedin profile?