Post reply

How to move a file from one database to another

  • March 10, 2005 at 7:33 am

    #163819

    Hi Guys

    I need to know how do i move a file from one repository to another. In sequel server, I am using a file called DATA in the HOP repository. I am running a query and want to insert a command after that query that takes the DATA file and moves it into another repository called DATA NATIONAL. Is this possible?

  • March 10, 2005 at 7:40 am

    #546370

    If you want to do this with Transact SQL, it is possible by using xp_cmdshell.

    See BOL for further details.

    /Kenneth

  • March 10, 2005 at 7:46 am

    #546372

    Thanks Kenneth for the prompt response. I am using sql sever 2000. Sorry for my ignorance, but what is BOL and where can i find it?

  • March 10, 2005 at 9:59 am

    #546425

    BOL = Books OnLine - it's the help files for MS Sql Server and can be found in:

    Start->Programs->MS Sql Server->Books OnLine

    Have fun

    Steve

    We need men who can dream of things that never were.

  • March 10, 2005 at 11:21 pm

    #546542

    Hi Steve

    Thanks for that. But i still cannot find anything? Can you help please?

  • March 11, 2005 at 12:48 am

    #546548

    BOL comes as an option to install when installing the client tools for SQL Server. It's a real must-have documentation, and always the first place to go when you're wondering about something.

    If you don't have access to the SQL Server setup, you can also find BOL (and much more) on the net.

    BOL can be found here.

    http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

    /Kenneth

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply