Click here to Skip to main content
12,073,325 members (72,113 online)
Rate this:
 
Please Sign up or sign in to vote.
i am making a table in local database of sql 2005. i want to update my server database to add this table to it what i do?
Posted 29-Apr-13 23:20pm
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

try this

SELECT *
INTO NewTable
FROM TheFirstDB.Schemaname.OldTable


go through the liks in solution 1 of your Question
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 3

Hi,

You will use Linked Server Concept or SSIS packages.
I will give you the link for Creating Linked Server.
How to create Link Server with MS SQL 2005/2008[^]
SQL Server - Linked Servers[^]

Once you Create the Linked Server, then use Query as follows.
SELECT * INTO <linked_server_name>.<database_name>.<schema_name>.<table_name> FROM <local_table_name></local_table_name></table_name></schema_name></database_name></linked_server_name>

-- For SSIS Packages Pls Check in Googel Smile | :) Smile | :) Smile | :)
Regards,
GVPrabu
  Permalink  
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web03 | 2.8.160208.1 | Last Updated 30 Apr 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100