locked
How to merge two .mdf databases into one RRS feed

  • Question

  • User259881276 posted

    I have two databases in my program which has different functions and tables. One is for membership and roles, etc. ASPNETDB and the other has photos and albums.

    How to I merge/combine the two? What is easiest way to do that? I have SQL Server 2008

    Thursday, December 8, 2011 1:40 PM

Answers

All replies

  • User-1569591428 posted

    Create a third database and export data from each to the new database.

    Thursday, December 8, 2011 2:23 PM
  • User259881276 posted

    Thank you kindly!

    Is that easier than "merging" the two which someone suggested I do? And do I do that from within the SQL Server Management Studio?

    Gosh, its been so long since I worked with this stuff. If you don't do it often, you forget everything!!

    Thursday, December 8, 2011 4:04 PM
  • User-1569591428 posted

    Yes, you can use your sql server management studio. You can generate sql scripts to create the database tables,views and stored procedure and export the data to your new database.

    Thursday, December 8, 2011 6:12 PM
  • User259881276 posted

    My SQLServerExpress is telling me it will do it but I cannot save it. That I have to purchase something. Is that only way?

    Thursday, December 8, 2011 6:15 PM
  • User-1629709220 posted

    You should be able to generate the create scripts and run them in sql express

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, December 8, 2011 8:14 PM
  • User-369079532 posted

    Hi,

    Please reference : http://stackoverflow.com/questions/3932946/merge-2-sql-server-databases

    Hope it helps.

    Tuesday, December 13, 2011 4:23 AM
  • User1999579388 posted

    Hi RaeKC,

    I found this thread which is similar to your issue. It may help you.

    Please see:http://www.dbforums.com/microsoft-sql-server/1075307-combining-2-sql-databases.html

    Thanks.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, December 13, 2011 4:38 AM