How do I copy a adp database to a server?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have developed an access project on my laptop, and wish to transfer it to a
server. So uses on the network can use the database on the server, from there
PC's.
 
You can make a backup/restore or detach the database, copy the files .LDB
and *.MDF to the server and re-attach the database.

If you want to continue the development on your laptop then the use of a
synchronising tool like Red Gate SQL-Compare will be a real time saver.
 
Thanks for your reply Sylvain.
I am unable to use a backup as the server does not have access loaded. I
found the .LDB and .MDF files on my laptop. There are 2 that are the same
name as my database, do I also need the others that have been updated at the
same time? That is the mastlog.ldf, master.mdf, msdblog.ldf, msdbdata.mdf,
modellog.ldf, model.mdf files? I have not as yet detached or re-attached a
database, I will have to do some work on this, are you able to give me any
pointers. Kind regards, Ed.
 
Even if you don't have Access, you can use SQL-Enterprise manager or any
tool that will execute SQL code. (The latest incarnation of SQL Server 2005
Management Studio Express (SSMSE) might be the ticket for you but I didn't
try personally:
http://www.microsoft.com/downloads/...FD-319A-4887-BC75-3B02B5E48A40&displaylang=en
..)

You only need the 2 files that have the same name as your database. (In
fact, only the .MDF is really necessary - especially if you are using the
simple recovery model - but it's simpler to go with these two files.)

See http://www.15seconds.com/issue/050127.htm for more informations,
particularly the other links at the bottom of this article.
 
Back
Top