SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software

Development Forums for Programmer, Administrators and Users

Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.

transfere data between two branches

Last post 05-04-2012, 3:32 PM by eralper. 1 replies.
Sort Posts:
  •  04-30-2012, 10:28 AM 34098

    transfere data between two branches

    Hi guys i want to copy all data only not objects from one sql server 2005 database to another
    sql server database 2005 but two databases are located in different locations meaning not in same network.all objects in two databases are same but different only in data. which best solution to take data only from one branch to main branch
  •  05-04-2012, 3:32 PM 34104 in reply to 34098

    Re: transfere data between two branches

    Hello Ahmed,
    I understand you cannot create a linked server between two SQL Server database instances.
    Did you try creating SQL Insert statements for data that is stored in source database table?
    Creating a insert script can be a solution of course data is not too big.

    An other dummy solution can be creating a new database, copying source table into new database.
    Then you can attach database in the target SQL Server instance and compare these two database objects using T-SQL or third party tools like xSQL Data Compare

View as RSS news feed in XML
Copyright © 2004 - 2018 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems