Re: Copying SQL Data from one m/c to another

Author: Ajoy Khaund

Posted: 2011-08-27 at 15:59:27

Currently I develop desktop applications with Vfp 6 & 9. The data entry to

the databases are been done by say operators in desktops. The owner

generally has a laptop and he likes to copy the data to his laptop in the

evening so that he can evaluate the work done so far.

Now the operators copy the data to a flash drive and gives it to the owner

when they leave for home. Will the sql process be as easy as that or very

different.

--------------------------------------------------

From: "Stephen Russell" <srussell705@gmail.com>

Sent: Saturday, August 27, 2011 5:43 PM

To: <profoxtech@leafe.com>

Subject: Re: Copying SQL Data from one m/c to another

> On Sat, Aug 27, 2011 at 5:16 AM, Ajoy Khaund <akhaund@gmail.com> wrote:

>> Hi,

>>

>> If SQL Server Express Edition is installed in two computers, then can I

>> just copy the data folder from the first machine and paste it to the

>> second machine.

>> Is that possible or is it something completely different?

> -----------------

>

> Read up on detach and reattach.

>

> There are data meta databases as well as your database. The databases

> have an ID for the SERVER they are on

> detach will open up the ability to bring in a new server to as as the

> host.

> --

> Stephen Russell

>

> Unified Health Services

> 60 Germantown Court

> Suite 220

> Cordova, TN 38018

>

> Telephone: 888.510.2667

>

> 901.246-0159 cell

>

[excessive quoting removed by server]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/62DA12F063B842AD8C338D943312A24F@ajoykcompaq

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2011 Ajoy Khaund