Coming Soon: GET:IT Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET Coming Soon: GET:IT Endpoint Management 1-Day Conference on September 28th at 9:30 AM ET

Merging data in database in SQL Server 2012

Home Forums Other Microsoft Servers and SaaS SQL Server 2005 / 2008 / 2008 R2 / 2012 / 2016 Merging data in database in SQL Server 2012

Viewing 1 post (of 1 total)
  • Author
    Posts

  • salim71
    Member
    #166521

    Hello,

    I am using SQL Server 2012. I have 2 databases, DB1 and DB2. DB1 contains data for the month of January, February and March. DB2 contains data between February to June. I would like to move the data from DB1 to DB2 so that DB2 contains data from January to June. I have used SQL Server Import and Export Data Wizard and it wizard completed successfully. However I ran into an issue. When I query DB2, I can see duplicates records. Does anyone know how I can merge data without duplicates? Any help is greatly appreciated.

    Thanks

    Salim

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

Live Webinar: Active Directory Security: What Needs Immediate Priority!Live on Tuesday, October 12th at 1 PM ET

Attacks on Active Directory are at an all-time high. Companies that are not taking heed are being punished, both monetarily and with loss of production.

In this webinar, you will learn:

  • How to prioritize vulnerability management
  • What attackers are leveraging to breach organizations
  • Where Active Directory security needs immediate attention
  • Overall strategy to secure your environment and keep it secured

Sponsored by: