Member Avatar for KeiHimekawa

Hi guys. Hope you can help me with my problem here.. It's quite complicated so I'll try to explain it in a very detailed manner..

I have these two databases which we may call dbaseA and dbaseB. I created another dbase which we call dbaseC. dbaseC is going to be used as a database which holds records from dbaseA and dbaseB.

Questions:
1. How will I merge records from dbaseA and dbaseB into dbaseC?
2. dbaseA and dbaseB have different schemas, meaning there are tables which are present in dbaseA but not in dbaseB and vice versa. We're following the schema of dbaseB for dbaseC. I need to get the records from dbaseA and dbaseB then put all of them in dbaseC.

I've tried replication, exports and imports but still, dbaseC still holds no records. It only followed a certain schema and nothing more..

Please help.. Thanks a lot =)

  • 2 Contributors
  • 1 Reply
  • 108 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by MCP
Member Avatar for MCP

I'm not too familiar with SQL Server's replication feature.

For your import/export however, what error messages did you get while trying to move data from dbaseB to dbaseC? If it's the same schema, I'm not too sure why you wouldn't be getting the data.

If there's referential integrity defined on the tables, you might have to do some tweaking first....

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.