import data from other database

  • how would you import data from other data base

  • Hey Phil, how are you? Are you using SQL Server 2000? If so, the best way is to use DTS. If want to import a table (not necessary to be mapped to your database) just open a new package. Your source will be the database from where you want the data from, and the dstination where you want to place the table. If the data you need to import needs to be mapped, then within the DTS package you create select the source (could be a query, a view, stroed proc, or a table) and map it to the table you want that data to be appended. BOL can give you more detail explanation on how to create DTS packages. There is also few books that can help you out, one in particular (sorry don't remember whole name, but is something like "Professional SQL Server 2000 DTS ..." ) Good luck

  • Another approach is to use Linked Servers (IF the database is on a different server)

    OR you could do something like SELECT fields... FROM DBNAME.OWNER.OBJECT



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

Viewing 3 posts - 1 through 2 (of 2 total)

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