Copy an msde database to a remote sql server and vice versa

[jlitondo]

I have a production database residing on a remote sequel server that I can access indirectly through a citrix connection.

However, because my database front end resides on my local machine, I chose to have my development database on my local machine as well, running in MSDE 2000.

Problem is, how do I upload one or all objects(including tables,stored procedures etc) in this msde based database to the sequel server based database?

I am using adp to interface with the msde database and using it I was able to run the copy database wizard which created an mdf for me. I was hoping that I could simply copy this and replace the mdf on the sequel server but that doesn't cut it.

How would I on the other hand copy the sql server db to msde on my local machine?

Anyone know how to do this? Thanks in advance.

 

[jlitondo]

Well - making this work was actually simple in a sense. What I did was ensure that there were no active connections to the database on the remote server then detach it and copy the mdf and ldf files to my local pc.

From adp I established a connection to my local server and attached the database by browsing to the physical location of the files (options provided on dialogue). It seemes a little crude but it works - got all objects including tables, stored procedures, udfs etc transferred back and forth.

The one gotcha I saw was that inorder to reattach the database to the remote server, both the database and file names of the two files must remain the same on both ends.