How I moved my SQL PA9 database

LexisNexis Practice Advantage 9 Enterprise
Moving from SQL 2000 Sp 3 on MS SBS2003 (S1)
Moving to SQL 2005 on MS SBS2003 R2 (S2)
The order of events is the most important part. Begin with a SQL db file backup from S1 and clean SQL 2005 install with instance name PA9 on S2
1. Run tmutile.exe to create intial SQL db tables. This will create the AdminCTL.tps file. My case also changed the tm9user password from weak to strong.

  • Make sure to set the SQL server name correctly in this step.  Needs to include the server name followed by the SQL Instance name. Ex: servernamePA9
  • Change the database name to LNTPA9 and LNTPA9_Tutor
  • Changed tm9user password (forced me, because old pass was weak)
  • exit tmutile.exe

2. Delete the database objects (LNTPA9 but not tm9user) using SQL manager
3. Create new db with same name. Set DBowner to tm9user. Run PA engineer’s script:
Subject: Script
use [TimeMatters9] — *** SUBSTITUTE TimeMatters9 WITH THE NAME OF THE DB
declare @DBname as varchar(500) set @DBname = ‘TimeMatters9’ — *** SUBSTITUTE TimeMatters9 WITH THE NAME OF THE DB
declare @DBowner as varchar (500) set @DBowner = ‘tm9user’ — *** SUBSTITUTE tm9user WITH THE NAME OF THE DB OWNER/USER
exec (‘sp_defaultdb [‘+@DBowner+’], [‘+@DBname+’]’)
exec (‘sp_change_users_login @action=update_one, @usernamepattern=[‘+@DBowner+’], @loginname=[‘+@DBowner+’]’)
4. Test Connection


Batch Convert Images using ImageMagick

I am using ImageMagick 6.4.1 convert.exe feature to batch convert multiple files. Usually this is from TIF to JPG or even a large JPG to a smaller size. Here is what I have so far:
1. Open cmd and cd “C:Program FilesImageMagick-6.4.1-Q16”
2. convert c:tempfile.tif c:tempfile.jpg (this works)
3. or go into directory containing files to convert
4. mogrify -format jpg *.tif (AHA! This preserves file names!)
I just used this mogrify command to batch resize.  However, it OVERWRITES the originals, so keep that in mind.
5. mogrify -resize 1024 *.jpg
ImageMagick Install:


Gallery2 Ebony Theme

Well, I have struggled with the ebony theme, but finally figured most of the quirks out. For some reason, the slideshow doesn’t work with only this theme, so I just disabled it. I really, really, really like the look with the reflections, so I’ll live. Slideshow didn’t work in the Gallery2Beta I had installed before anyway. Then I had to figure out Dynamic albums with URL_Rewrite and figure out how to edit my server apache config files. I should have kept better notes. Most Viewed and New additions links in Gallery2 work now (in the sidebar) as does download cart in ZIP (very cool). XP Web Publishing Wizard isn’t working (very cryptic error…) but I managed to mount the db with webDav, so who cares?! Something about how many ways there are to skin a cat… Oh, and I think I got the RSS Feed to work.