The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Copy a database
Posted: 26 Jul 07 8:12 AM
|
| I wish to copy an entire Saleslogix database can someone provide me with the correct guidelines please? |
|
|
|
Re: Copy a database
Posted: 27 Jul 07 4:06 AM
|
Simply back it up via SQL EntMgr or Studio.
If you want the documents/libs then look in the Admin tool for the Library Paths and Documents paths - back those up too. |
|
|
|
Re: Copy a database
Posted: 27 Jul 07 4:22 AM
|
| I now wish to make a copy of this database from the backup, is there anything I should be aware of? I do not wish to overwrite the original database and only want the copy for development purposes. Note both databases are in the same location. Also once I have made the copy how do I make the data link so that I can log onto the database via the data link manager (using version 6.1)? |
|
|
|
Re: Copy a database
Posted: 27 Jul 07 4:32 AM
|
This rather depends on whether you are using remotes or not. Let's assume not for the moment. To restore, simply create a new database - place the MDF/LDF files in a place of your choice. Now, in EntMgr/Studio - select logins and grant permissions for the sysdba user for this database - ensure you select db_owner as the role. Select the task restore - point to the backup you created earlier and use the ellipses on the file locations to point to the MDF/LDF files created in the earlier step FOR YOUR COPY DATABASE - NOT THE ORIGINAL ! Once restored, you use SLX Connection Mgr to create a new connection to that database as normal and in the client, point to the new connection.
If you have remotes - do exactly the same as above but PRIOR to logging in (directly after the restore) - ensure you run this:
UPDATE sysdba.SYSTEMINFO SET PRIMARYSERVER = 'NOSYNCSERVER' WHERE SYSTEMINFOID = 'PRIMARY'
go
UPDATE sysdba.BRANCHOPTIONS SET SITECODE = 'NOSYNCSERVER'
go
UPDATE sysdba.SITEOPTIONS SET HOSTSERVER = 'NOSYNCSERVER' WHERE HOSTSERVER IS NOT NULL
go
This removes sync server details and reomves w/group logging. You should also examine the branchinfo table and alter the paths to ensure you don't trample over the live library/documents folder.
|
|
|
|
Re: Copy a database
Posted: 27 Jul 07 6:22 AM
|
| all done except for one thing - I can not see SLX connection manager anywhere on both the server and the client installs. I have checked under program files. Unfortunately we do not have the original SLX media, copied files were given to us by our Business Partner. We are using version 6.1, and have no remote access requirements. |
|
|
|
Re: Copy a database
Posted: 27 Jul 07 6:37 AM
|
| You must have it somewhere - otherwise SLX can't connect ! Check on the servers - it will be in the program group SalesLogix and called Connection Manager. You will be able to tell which server it is on by editing an existing link - if you still don't find it - look in program files for OleDBConfigMgr.exe and run that (that's Connection Manager) |
|
|
|
Re: Copy a database
Posted: 27 Jul 07 6:49 AM
|
| I have found this file, it was on the server. However when I run it it displays 'class not registered' on clicking ok it then displays the connection manager window but without any current database links. I do not wish to overwrite anything. |
|
|
|
Re: Copy a database
Posted: 27 Jul 07 6:54 AM
|
| Hmm, I'd go back to the BP to to find out why this is - I wouldn't want to do anymore in case I break it ! |
|
|
|
Re: Copy a database
Posted: 27 Jul 07 6:57 AM
|
| will do so and thanks for all your help - much appreciated. |
|
|
|
Re: Copy a database
Posted: 30 Jul 07 8:28 AM
|
Just to let you know the error message I was getting was due to not connecting to the server directly, as soon as I did this I managed to add the new database. Another question though I have tried to add the copied database into the login screen but am getting the following error message
'Saleslogix OLEDB security - open connection login failed for user 'sysdba' in saleslogix'. Any idea as to why this is happening? |
|
|
|
Re: Copy a database
Posted: 30 Jul 07 8:39 AM
|
you may need to run the sysdbafix_script.sql (it is on the SlxCD in the database folder.
also, if you installed the database on a seperate server you may need to create the SQL sysdba logon. |
|
|
|
Re: Copy a database
Posted: 30 Jul 07 9:02 AM
|
| the database is on the same server, I ran the above script on the copied database but am getting the an 'invalid Saleslogix Password' error message. |
|
|
|
Re: Copy a database
Posted: 31 Jul 07 7:14 AM
|
Originally posted by Chokri
all done except for one thing - I can not see SLX connection manager anywhere on both the server and the client installs. I have checked under program files. Unfortunately we do not have the original SLX media, copied files were given to us by our Business Partner. We are using version 6.1, and have no remote access requirements. |
|
You should have an original set somewhere... ALL clients get a "kit" sent to them from Sage. Although (way) back in the 6.1 days Sage would send the kit to the BP and the BP is supposed to GIVE it to you..
Ask your BP for your kit.. it belongs to you .. not them!
--
rjl |
|
|
|