slxdeveloper.com Community Forums

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!

Administration Forums - Database Administration
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Database Administration | New Thread

View: Search:

Author

Thread: Moving database from one SQL server to another.

Jeff L
Posts: 65

Moving database from one SQL server to another. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 09 Mar 09 12:08 PM

Hi all,
We have two instances of SLX. One ‘live’ one ‘dev’. They reside on different servers. Each is fully functional. Each instance has it’s own SQL database server. The Live instance is the one our company will expose to users when we go live with SalesLogix in the fall.

I have been doing all development work on the dev server while Sales Mangers etc. have been ‘playing’ and learning SalesLogix and requesting customizations on the Live server.
It’s now time to move all modifications from dev to live. My plan was to simply copy the dev database to the live server and create a connection on the live server.

I did a back up on the dev server and did a restore of that backup on the live server. My problem is with the sysdba logon on the live sql server. I cannot set the user mapping for login sysdba to the newly restored database. The error states that ‘User, group, or role 'sysdba' already exists in the current database.’ This problem prevents me from creating a connection in the SLX Connection Manager.

Can some please help me over this hurdle? I really don’t what to go through the hassle of individually selecting each and every plugin and database change to create a bundle. The changes are extensive.

FYI, relations have soured somewhat between my company and the SLX var, so I am asked not to involve them.

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Moving database from one SQL server to another. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 09 Mar 09 1:52 PM

Your sysdba user became orphaned when you moved from one server to another. Try running sysdbafix_script.sql (from the database folder) to fix this.

[Reply][Quote]

Jeff L
Posts: 65

Re: Moving database from one SQL server to another. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 09 Mar 09 3:26 PM

That worked.

Thanks Phil.

[Reply][Quote]

RJ Samp
Posts: 973

Re: Moving database from one SQL server to another. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Oct 09 1:35 PM

Don't forget to change the logging paths, library path, docs path through SQL (not through SLX) anytime you move/restore a database to another server.....

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 4/20/2024 8:39:17 AM