We love Liberum Help Desk but we'd like to migrate our exisiting tickets from our old database into our new SQL database. i've been running in in a test enviorment but can't find a clean way to transfer. Any suggesetions?
Luckily you're trying to migrate out to MS SQL which is pretty simple and not to MySQL which is far more fun.
If you are using access 200 then go to >Tools > Add-Ins > Upsizing Wizard this should prep your existing database structure and data for porting out to MS SQL.
If you're using SQL Server 2005 on then you should find the SQL server migration tool for access ought to do what you want.
These are all available from MS.
This worked.
Opened the database in Access 2007
created a DSN to my new database
clicked on Database Tools in the ribbon, Move Data-SQL Server (after trusting the database)
pointed to the new data base, selected all the tabels, accepted all the defaults crossed my fingers and it's working!
For anyone trying the Office 2010 beta, you have the same migration tools available as the '07 version.
For anyone wanting to port access out to MySQL then this is a pretty good tool
http://www.chsoftware.net/en/useware/dbconv/dbconverter.htm