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: Copy Database to production server

Dipak Salve
Posts: 17

Copy Database to production server Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Nov 07 2:00 AM

Hello All,
I have one database of SalesLogix (Destination & production server on site) which is empty and i want to copy the data from other SalesLogix database (source) & i have saleslogix.mdf file & ldf file of souce,
please guide me to copy ...

Thankx in advance...

Regards,
Dipak Salve

[Reply][Quote]

Jeff Weight
Posts: 219

Re: Copy Database to production server Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 Nov 07 4:24 PM

I guess there are a few questions to be answered. First, are the source and destination databases completely identical as far as schema is concerned, or is this more of a data import from a database of a different type? If the databases are the same schema-wise, do you need anything from the destination database?

If the answer to the first question is yes and the answer to the second question is no, then I would just backup the destination db, drop the destination db, and then attach the MDF of the source.

If the answer to the second question is no, then you just need to attach the source database to the destination database's server, and then either invest in a data migration tool like scribe, or script out the SQL yourself to grab the data from the source and insert it into the destination.

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Copy Database to production server Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 03 Dec 07 9:02 PM

Bear in mind when copying from a Production db to a Dev db that you should turn off synchronisation in the dev db, or you could be lining yourself up with some major sync headaches.

Also BACKUP/RESTORE is a better method than DETACH/copy/ATTACH in my opinion. If you ask for reasons, I'll have to refresh my memory, because I can't remember them!

PP

[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): 11/25/2024 4:51:43 PM