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!

Web Forums - SalesLogix Web Platform & Application Architect
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Web Platform & Application Architect | New Thread

View: Search:

Author

Thread: Moving the DB from sql 2005 to sql 2008

NagaratnaPandi
Posts: 111

Moving the DB from sql 2005 to sql 2008 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Aug 09 11:10 AM

Hi all,

I have made all the installation and customization on the sql 2005 .Now i want to move this db to sql 2008 .So what should i do to move the DB to sql 2008 .The if i move the db to sql 2008 should i re build and deploy using the new connection TO SQl 2008 dB.

Thanks,
Pandi

[Reply][Quote]

Lucien
Posts: 20

Re: Moving the DB from sql 2005 to sql 2008 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Sep 09 3:57 AM

Hi
Copy the .mdf and ldf files to another folder, then in 2008 sql server, attach those mdf and ldf files to a new database

Regards
Lucien

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Moving the DB from sql 2005 to sql 2008 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Sep 09 5:44 AM

Quote:

Originally posted by Lucien

Hi
Copy the .mdf and ldf files to another folder, then in 2008 sql server, attach those mdf and ldf files to a new database

This is one way to do it, but keep in mind that you will have to Detach the database before proceeding.
Also, you need to ensure that your sysdba login and schema exist on the new server and then re-map then on the new DB.

An alternative is to do a Backup and Restore of the database (same challenges apply).

And you could also use the "Copy Database" wizard on SQL Management studio 2008 to move the Database with all required objects to the new 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 © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 7/4/2025 6:00:25 PM