Post reply

Importing SQL Server 2005 tables from local to server

  • February 14, 2009 at 3:12 am

    #134686

    Hi All,

    I have a table with 50 records,the same table is in server with 25 records ,now i want to import the

    table from local system to server,in my sqlserver express there is no option as import

    or export.how to import , give a query please.

    Thanks in Advance,

    Regards

    Selvamariappan.c

  • February 14, 2009 at 3:39 am

    #944049

    ..Create a linked server in your local server using sp_addlinkedserver and a remote login mapping using sp_addlinkedsrvlogin. Then do a cross server select/insert query using four-part naming convention.

    --Ramesh

  • February 14, 2009 at 3:45 am

    #944051

    Thanks for Your Reply, But I cant Get You,I want to import the data from one table to another server table

    Regards

    selvamariappan.c

  • February 14, 2009 at 3:52 am

    #944054

    ...You can also connect to a remote server using OPENROWSET function. Check in Books Online for OPENROWSET function, it has an example on connecting to a remote sql server....

    --Ramesh

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

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