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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

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