LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   General (http://www.linuxquestions.org/questions/general-10/)
-   -   Copying a file from Database Server?? (http://www.linuxquestions.org/questions/general-10/copying-a-file-from-database-server-539191/)

bobb_roof 03-20-2007 09:48 PM

Copying a file from Database Server??
 
In our w2k3 LAN, My data (an XXX file) resides in a database server (MS SQL Server 2000). i do access and work with this file from an XP workstation (Laptop). Usually i must access the server to get to this file, so the question is how do i make a copy of this file in the local station so that i can work on this XXX file with my notebook while on a trip?

Crito 03-21-2007 05:09 AM

You can use MS Access and import the data or you can install the developer edition of SQL Server and simply attach your existing database files.

bobb_roof 03-22-2007 05:51 AM

thanks Crito, but in my MS application when i open it, i simply cannot see an option for IMPORT from the File Menu and even from all the Main Menu, Tool Box, etc. can you give me a clearer way of doing this import?

Crito 03-22-2007 09:08 AM

I don't have Windows in front of me ATM, but you need to import it into something, so create an empty database first. Then I believe the menu item was called "get external data", under which you had the options to "import" or "link".


All times are GMT -5. The time now is 01:20 AM.