User Profile

Collapse

Profile Sidebar

Collapse
ammie
ammie
Last Activity: Mar 27 '07, 04:48 PM
Joined: Mar 27 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ammie
    started a topic Merge data in SQL Server databases
    in SQL Server

    Merge data in SQL Server databases

    I have two databases with identical tables structures. I need to merge the data in both databases without implementing merge replication. Can someone tell me what script to run that will compare the data in those tables? First I know the script has to search for data that doesn't exist in one table, the copy that over from the table that has extra rows. Thanks

    Ammie
    See more | Go to post
    • ammie
      replied to importing a database into ms sql server
      in SQL Server
      -----
      Where are you importing the database from? There are several options depending on the platform. You could backup and restore, detach and attach or use Data Transformation Services. All that depends on whether you're geting the data from another sql server, an oracle server, a flat file or etc....

      ammie...
      See more | Go to post

        Leave a comment:

      No activity results to display
      Show More
      Working...