Post reply

move all data from first sql server 2005 database to second database sql server 2005 two are same

  • December 6, 2012 at 8:00 am

    #265863

    I have two databases these two databases have same structures and objects but different only in data

    Are there are any way to transfer data(only) from one databases to another.i try to make replication but no connection mode between us.Now How i solving these problem please help me

    these two database working in sql server 2005

  • December 6, 2012 at 11:33 am

    #1566288

    ahmed_elbarbary.2010 (12/6/2012)

    I have two databases these two databases have same structures and objects but different only in data

    Are there are any way to transfer data(only) from one databases to another.i try to make replication but no connection mode between us.Now How i solving these problem please help me

    these two database working in sql server 2005

    Backup/restore is your easiest solution, I would suggest.

    Replication via log shipping is another idea - you don't need an 'always on' connection to make that work.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 2 posts - 1 through 1 (of 1 total)

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