Member Avatar for rajshkhr

Hello to all,

I am using MS SQL 2005. I have created 5 databases in it will same tables structure. The table contains the data in same structure. Now I want to merge all the databases in one database so that I can have all the data in respective tables.

How could I approach it?

So that I preserve my data in the database with all reference working as it is working previously and no miss match occurs.

Help me please.

Thanks in advance.

  • 2 Contributors
  • 1 Reply
  • 58 Views
  • 18 Hours Discussion Span
  • Latest Post Latest Post by kinetikit
Member Avatar for kinetikit

With the help of MySQL you can merge the whole data. It's very easy, creative and interesting way.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.