No data transfer utility with SQL Server Management Studio Express 2005

That's correct, with the express version there is no import/export facility.

There may (or may not be) this facility with the developer edition, think there is though, but seeing as I'm running a new install I was going to go with 2008.

However, had fun with that last time so I'm going to try something new, with the DTS tool which I read about.

STEPS TO ADD DTS WIZARD WITH SQL SERVER MANAGEMNT STUDIO EXPRESS

1. Try "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe"
If it worked, you already have the DTS Wizard. Start using it right away.

If it will not work, continue to step 2

2. Download the Microsoft SQL Server 2005 Express Edition Toolkit (223.9 MB) from

http://go.microsoft.com/fwlink/?LinkId=65111
select all components to install

3. Run "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe"

Thats it.. Now you can transfer data using the the great DTS wizard.

Follow the steps If you want to integrate it with the Sql server management studio express UI .
1. Open sql server management studio express.
2. Select Tools -> External Tools
3. Add a Title and Browse C:\Program Files\Microsoft SQL Server\90 \DTS\Binn\DTSWizard.exe for the Command field.
3. Click OK Retweet this button on every post blogger

Importing data from SQL Server to MySql

You'd think it'd be an easy import from one of the tools right, well it doesn't appear that way... although I may well be wrong.

There were a few different migration tools so I weighed up all the options and just went for the first one in the list MSSQL2MYSQL. Straight away I encountered problems, I tried to run via a VB app (Word can do this supposedly), and I hit a runtime error. A little bit of digging and it becomes appartent this is a classic VB error and the activeX dll needs registering or there is something wrong with my VB runtime. I install the latest copy of VB and do a restart.

I then spot that there is a MySQL migration tool kit that would appear to do all I need. It is a very easy to use GUI editor.... thumbs up to the MySQL team! Retweet this button on every post blogger

SugarCRM and SQL Server 2008

There is currently no support for SQL Server 2008 within the sugarCRM. This is quite frustrating as I've spent the best part of a weeks free time getting this going only to see it be v.buggy and unusable.

There was a blog post that it was available for the 5.5 beta version, and even had an update in the user documentation to the affect. However, the blog posts date was after the file update date, and when attempting the instal with this SQL server was not appearing as a database option. I always thought open source, not re-inventing the wheel was supposed to be quicker!

So, my plan is now to instal and run off of MySQL, which will be a new thing for me. Hopefully should work ok otherwise I'm in danger of becoming a right miserable git. Retweet this button on every post blogger