I have a MSDE database on a laptop and need to copy it to another machine in order to use Access 2000 to inspect the tables and view the data using an Access project adp file.
Could someone please tell me how to do this and whether there are any relevant issues/problems.
thanksBACKUP and RESTORE work fine. There's just no GUI
You can do interactive tsql by Navigating to
C:\Program Files\Microsoft SQL Server\80\Tools\Binn
THEN type osql -E -r1
------------------------
Handy Instructions
Type in your tsql commands (BACKUP \RESTORE\Whatever)
For the TSQL reference, go to
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_00_519s.asp
To execute these commands, on a line by itself type "GO"
to QUIT, on a line by itself type "QUIT"sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment