Hi Kear,
Looks like what you are looking for is a script to automate your manual process of uploading and downloading databases. What are the actual commands you use for uploading and downloading? Maybe perl/python or another such scripting language that you are familiar with will be the right tool. These languages are much easier to pick up than a traditional programming language like C, Java etc and there's a large collection of examples, libraries, online help etc. See CPAN.org for Perl as an example. Hope that helps! Manish Grewal Senior Consultant [cid:[email protected]] www.headstrong.com<http://www.headstrong.com/> > -----Original Message----- > From: Michael Kear [mailto:[email protected]] > Sent: Monday, January 05, 2009 5:53 AM > To: sql > Subject: RE: How do i . Copy a database to a remote server? > > Incidentally, just as an additional comment to my plea ... > > I cant use the copy database wizard, because it's a shared server and I > don't have admin rights. So I cant create a database on the remote > server > using SQLServer management studio. > > For the same reason I cant create a backup and then restore it on the > other > server.. > > For the same reason I cant use replication in any way. > > For the same reason, detaching, FTP then attach to the other server is > out > as well. > ***The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review,retransmission,dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.*** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3168 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
