create procedure

Question

create procedure

VastSQL

SSC-Dedicated

Points: 36097
More actions
October 6, 2009 at 3:24 am

#96341

Hi Experts,
I want to copy and the tables from one server to another i tried to create a procedure in which i wil give the table name so that particular table weil be copied
create proc copytbl
declare tblname varchar(100)
as
select * into @tblname openquery ([DB2-21], 'select * from chema_name.@tblname')
Is there any other way to achive the same.
PLEASE HELP ME IN WRITING THIS PROCEDURE
TIA

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

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

dmoldovan SSCertifiable Points: 6334 More actions · Answer 1

Consider using SSIS or the "import and export wizard".

See also http://msdn.microsoft.com/en-us/library/ms175937(SQL.90).aspx and http://msdn.microsoft.com/en-us/library/ms190923(SQL.90).aspx.

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 2

Why not just restore a backup?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

vishkk47 SSC Enthusiast Points: 127 More actions · Answer 3

This should work

select * into x from [Linked Server Name].[Database Name].dbo.TableName

Caution: The above statement will just create x table with data copied from TableName and will not copy the keys, contraints and index from TableName

ChiragNS One Orange Chip Points: 26137 More actions · Answer 4

ChiragNS

One Orange Chip

Points: 26137

October 12, 2009 at 3:21 am

#1064627

Why not SSIS

"Keep Trying"