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?

TIA

Regards,

Ajoy Khaund

Neamati Road

Near Bhogdoi Bridge

Jorhat 785001-21

Assam, India

Cell: +91-9435092287

Fixed: +91-376-2351288

Mail: akhaund@hotmail.com

Blog: http://teaanalyst.blogspot.com/

Downloads: http://cid-40c8c3127198e7ff.skydrive.live.com/browse.aspx/Public

"Walking on water and developing software from a specification are easy if both are frozen."

- Edward V. Berard, "Life-Cycle Approaches"

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

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/3D1E6857536A4D83A2F157DD82E7E92D@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.

On Sat, Aug 27, 2011 at 11: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?

Hi Ajoy, it should work if you un-mount the source database and

re-attach on the destination.

A better approach is to use backup/restore.

Mirroring and replication are 2 other options but not supported by SQL Express.

--

Paul

_______________________________________________

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/CADwx0+++RWZqaCgBNCWGWuN+NQLm1FwYZSXnYDvJJXWQs+QuMQ@mail.gmail.com

** 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.

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

_______________________________________________

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/CAJidMYJ-cZt0c+hfa_p9GaGdu3WW_Okfu_atjMXkhQJ73UWBHQ@mail.gmail.com

** 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.

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.

On Sat, Aug 27, 2011 at 2:59 PM, Ajoy Khaund <akhaund@gmail.com> wrote:

> 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.

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

Well it will be different then. Just make a linked server and update

his to go. I don't know your schema and it may be are RPITA to

achieve this.

One thing I have to ask is what do they want it? Work from home? You

could set up a web page to access for reporting letting the boss know

"what happened" via a dashboard.

--

Stephen Russell

Unified Health Services

60 Germantown Court

Suite 220

Cordova, TN 38018

Telephone: 888.510.2667

901.246-0159 cell

_______________________________________________

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/CAJidMY+j7_2hD-Ukg09eQomKF5FDHqCV+K7NP3m484xdkYeepQ@mail.gmail.com

** 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.