Removing Demo data from V6.0 SQL stack

[LuckiestBoy]

Well having struggled with SugarCRM CE (MySQL) FastStack for a month, I went for SQL Stack.

Nothing wrong with MySQL but I just could not restore a back up ...would have been risky in the long run to stay with MySQL..

MS_SQL seems to be more responsive and backups ...restore. So far so good. Now to headache. I installed it twice (thinking maybe I ticked the wrong thing). I definitely told it NOT to install demo data but it still did.

I want to remove demo data completely but am left with Case numbers that start at 51, 500 User Feeds that I can delete one be one and then there are users and employees. It's like moving into a new house that still has Aura from previous occupants.

I tried creating another database and edit config.php but that gives me the error "You can only use version 6.0.0 data files with SugarCRM 6.0.0

Any idea how I can flush demo data or create another database to use, please.

[roblaus]

1. Restoring a MySQL backup is as easy as creating it. Rename your old database, create a new empty one with the old name, select it, click import and choose your (sql) backup file. That's it. Of course you should be using phpmyadmin which comes with the stack installer.

2. Provided you want to start from scratch with your existing version: edit your config.php and set the line "installer locked" from true to false. Then call Sugar as usual and you will be presented with the web installer screen. Follow the instructions on the screen. If you choose the same database name you will receive a warning that your old data will be overwritten but this is what you want I guess.

[LuckiestBoy]

Thanks Roblaus. I tried both.

1 - used phpmyadmin and that gives me a syntax error. Posted a question re this but no replies yet.

2 - Even when I tell MSSQL stack to not install Demo data, it installs it and I am still trying to figure out how to fluch it out. Manual deleted most entries but users remain. So, wiping out just gives me same data again. That I suppose is Bill Gates' revenge or spike for having to give it away free.

Backup/Restore works without a hitch after spending few hours in their forum

[roblaus]

Did you do what I told you? Change the config.php and run the web installer? I have done this a couple of 100 times with and without demo data and it definitely works.

[LuckiestBoy]

I did that (2) this evening.

Installation said it could not attach to port 80 and 443 - incremented both by 1 it installed another SQL caboodle instance and came with error half way through intallation

"Error copying file from D:/sugarcrm-6.0.0/php/ntwdblib.dll to D:/sugarcrm/apache2/bin.ntwdblib.dll"

I gave in the end.

Is there another way of creating a database. Then I could create a new one and delete the demo. I tried creaing one in SQL2005/Express but when I cam to open it, it said something to the effect that I could only data 6.0.0. with sugarCRM 6.0.0 or something very similar.

[LuckiestBoy]

Most of the evening gone into early hours of Friday.

I reinstalled SugarCRM 6 CE SQL Server stack. Created another database and named is sugarcrm_db and then tried all kinds of things to fool sugar. But no luck. I get the errors;

First time it says unable to select database and send time onwards it says;

"Sugar CRM 6.0.0 Files May Only Be Used With A Sugar CRM 6.0.0 Database"

What the hell, I created database in 6.0.0!!

Any thoughts as to how I could create a new database? Thanks in advance

[roblaus]

Sorry if I can't be of any further help. You may want to consult a professional somewhere in your area.

[LuckiestBoy]

Thanks jsut the same. This demo data is like a leech.

[LuckiestBoy]

Managed to wipe it off. Here is the low down. Applicable to MSSQLstack

BACK IT UP FIRST - I didn't and had to many installs

1. Open SQL Server Management Studio Express
2. Right click database > New Query
3. type
delete accounts
delete contacts
delete leads
delete ........
delete whatever else
DO NOT TYPE delete users or you will delete admin as well
I am sure there is a way of creating admin account but you need to know schema and certificate etc and I didn't. Sorry I am not a programmer and I cant can't afford to hire one http://www.sugarcrm.com/forums/images/smilies/smile.gif

4. Execute

WARNING: For users - Open table - right click delete i- ndividual users
If you make a mistake keep your fingers crossed, restore from backup.and start again. And Good Luck.

[trehman]

I deleted all demo data by going into list view and selecting "ALL". Except for Employees, that is. Guess Sugar does not let you do that.