Copying SQL Data from one m/c to another
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: akha...@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.
Re: Copying SQL Data from one m/c to another
On Sat, Aug 27, 2011 at 11:16 AM, Ajoy Khaund 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+q...@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.
Re: Copying SQL Data from one m/c to another
On Sat, Aug 27, 2011 at 5:16 AM, Ajoy Khaund 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_atjmxkhqj73uw...@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.
Re: Copying SQL Data from one m/c to another
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" Sent: Saturday, August 27, 2011 5:43 PM To: Subject: Re: Copying SQL Data from one m/c to another > On Sat, Aug 27, 2011 at 5:16 AM, Ajoy Khaund 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.
Re: Copying SQL Data from one m/c to another
On Sat, Aug 27, 2011 at 2:59 PM, Ajoy Khaund 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+k7np3m484xdkye...@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.
