Post reply

Change Database to match another

  • January 6, 2003 at 9:43 am

    #58439

    Hi Guys,

    I have two databases that are exact. I made changes to one database such as adding new columns to tables. I was wondering is there a way to change the second database to match the first one without having to go in manually and add the columns to each table?

    Thanks In Advance,

    JJ

  • January 6, 2003 at 9:48 am

    #445629

    No, best advice is to script things and run it against both databases. Similar to what I did here:

    http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

    http://www.dkranch.net

  • January 6, 2003 at 10:17 am

    #445632

    If you built a script for the first set of changes then you are home free, execute it against the second database. I'm guessing you don't have a script.

    You could also purchase a tool that would compare the schemas of one database with another. Might try a free download of compare software:

    SQL Compare by Red-gate.com

    or

    Change Manager from Embarcadero.com

    They might have free trial software that would do the trick. If so, I would purchase it so next time you'll have a tool to do what you would like.

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

  • January 6, 2003 at 11:38 am

    #445641

    Hi Again,

    Thanks for your reply. I should have gave all the details. For one I am using access 2002 frontend to a msde 2000 backend. I noticed that the data didn't change in the other database so I don't have to do anything.

    Thanks for your help anyways,

    JJ

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply