Results 1 to 3 of 3

Thread: how to link a database table with a new database

  1. #1
    Join Date
    Oct 2008
    Posts
    9

    how to link a database table with a new database

    Hey guys,
    I would like to know how to link an existing database table columns with a new database in which it will contain a table having the particular columns from the old database. This table in the new database should keep on getting the data from the old database table from the required columns as the data that is in the previous database keeps getting updated.
    Plz, reply fast as possible.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Set transactional replication in sql server. By the way, don't cross post same issue in multiple forums.

  3. #3
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    You could create a view and use the view.

Posting Permissions

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