08-28-2009 10:21 AM
We are upgrading SalesLogix this weekend from SLX v7.0 & SQL 2000 to SLX v7.5.1 & SQL 2005. As part of the upgrade, we are cutting new databases for all 175 of our remote users. Just looking for input on whether or not I should attempt to cut multiple databases at one time? Will that speed up the process or slow it down? We will have 3 people cutting databases, each working from a different Admin Workstation computer (using same SLX Server & same SQL Server). I plan on cutting the remote databases on the SQL Host. Does anyone have any advice for me? Thanks in advance!
08-28-2009 11:07 AM
3 different people logged into 3 copies of the admin and cutting at the same time?.. sounds risky! In 10+ years of SalesLogix.. we have never done it that way.
Just have one logged in and que the remote(s) for cut in as large a batch as you can handle. You will be wanting to copy off (and zip) the sxds as soon as they complete.. and be sure to trash the ldf's so that you don't run out of drive space.
08-28-2009 11:21 AM
08-28-2009 11:39 AM
.. yepper.. Timmy is spot on... you could setup admin "roles" and have individual's login as themselves (in wgadmin).. but cutting remotes is an area that can go very nasty.. very quickly.. and have "un-detected" errors.
It's a one "user" process... always has been..
08-28-2009 11:56 AM
Not exactly what I wanted to hear, but thank you so much for your advice. I really appreciate it! I guess I'd rather spend the extra time and make sure that the remote databases are cut correctly the 1st time. I'm expecting that it will take forever to cut 175 databases, but I don't think there's any way around that... unless you have any more ideas?
08-28-2009 12:03 PM
08-28-2009 12:37 PM
Timmus brings out a good point - having a copy of the admin on the SQL server and cutting there is the fastest way to do it. Just make sure the location where the cuts are going is shared out so that you can then grab the good stuff and delete the ldf's as you go along.
We have seen cuts go as quickly as less than 90 seconds (small db's of course).
08-28-2009 12:51 PM
I have one more question, if you don't mind. Do you recommend choosing the option to create the database on the SQL Host or to use a SQL Express instance?
08-28-2009 01:00 PM