Instructions how to dump database

[anicolais]

I have been trying to do this for a bit now but can't figure it out. I have a very small amount of data in my database but I want to take that data and upload it into another instance of sugarCRM. I was told to dump the database and re upload it but I cant figure out how to do this. Can someone please explain in clear detail how to go about this whole situation it would be greatly appreciated. Thanks!

Im using FastStack Windows Installer for 5.5.0R with SQL Server.

[Angel]

I have been trying to do this for a bit now but can't figure it out. I have a very small amount of data in my database but I want to take that data and upload it into another instance of sugarCRM. I was told to dump the database and re upload it but I cant figure out how to do this. Can someone please explain in clear detail how to go about this whole situation it would be greatly appreciated. Thanks!

Im using FastStack Windows Installer for 5.5.0R with SQL Server.

Download and install the SQL Server Management Studio from Microsoft. Either of the 2005 or 2008 versions should work.

Use that connect to the SQL Server and then use management studio to run a backup by right clicking the database and selecting Tasks > Backup

[anicolais]

OK I have the backup file. How do i then put this backup file into my New instance of SugarCRM??

Thanks

[Angel]

You'll need to do the reverse of what you did to create the backup.

So..

Use Management Studio to connect to the SQL server that corresponds with the new instance (assuming it is different than the SQL instance you are already using).

Next you'll want to create a new, blank database. Right click on it and then choose Tasks > Restore

That'll allow you to restore the database from the backup file you previously created. Make sure that when you perform your backup, the process is using the new databases files to store its data.

Lastly, you might need to update your config.php file to point it to the proper database.