Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Sep 2005
    Posts
    25
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Transfering data from one database to another

    Hi all,
    In an ASP-page I would like to transfer content of table in a database to another table in another database.

    I don't want to make use of opening RecordSets, because the amount of data is very large and this would take too much time.

    So, is there another way?

  • #2
    Regular Coder
    Join Date
    May 2007
    Location
    UK
    Posts
    180
    Thanks
    0
    Thanked 18 Times in 18 Posts
    If you are using SQL Server 2000 or 2005 (I don't know about earlier versions) as one of your databases then you can create a linked server. Just look up the T-SQL help for the sp_addlinkedserver stored procedure for details.

    I have successfully used this to copy data from an Access database to a SQL Server database with a single insert... select from statement. This also had the benefit of using T-SQL to access an Access database rather than having to use SQL-92 or whatever standard Access databases use.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •