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

Changing the datasource for Sugar

Sugar CRM was set up to run localy off of my PC but use a remote SQL Server datasource.

Not knowing much PHP it was a pretty easy instal. Things rarely run according to plan even when they appear to have been running smoothly. PHP didn't appear to maintain connections to the SQL server and was seemed to be gobbling up the CALs causing other sites to baulk.

New plan is to run off a local datasource that doesn't provide website's to other companies so that only sugar would be accessing. This would allow me to fully test out sugar without fear of killing a live site.

Step 1 is to open the config.php file in the root of the sugar system.

Within this file there are 3 points to edit

• dbconfig array
• host_name
• site_url

You will also need to ensure that if you are importing the data from another database that the database owner remains as dbo. This can be scripted afterwards but is quite time consuming if I recall correctly.

Update: There is a way to create a script to alter the DBO.

Simply update this SQL: SOMEDBONAMEGOESHERE

SELECT 'ALTER SCHEMA dbo TRANSFER ' + TABLE_SCHEMA + '.' + TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'SOMEDBONAMEGOESHERE'

And it will create all of the desired scripts... sweet! Retweet this button on every post blogger