Friday, February 17, 2012

Copy Table from Ms SQL Server to another

Hi there friends,
I've been looking in foruns for this problem, and i only found something about DST.

The problem is that, i've got two servers and i whant to copy a table from the first to the second. I now that i can use strings, maybe an select and an insert after. But i've been learnig SQL by my self, and i dunno how to do this. Can anyone explain to me how can i copy a table using script?

Thanks!DTS is the best method.

However, I've been bored before, and created an application that would get the entire table, and script out the contents of the table through use of a really nice set of loops. :)

What exactly do you mean by script? You can right click the table, and go to All Tasks > Generate Sql Script. Is that what you mean?|||Script like "select * from table".

i've managed to copy the table, but not the way i whant.

my question, is is it possible to copy something in diferent servers like:

select * from table
and then
insert into table...

Something like this.|||use the import and export tool deliverd by SQL server.|||i mean DTS :-)

No comments:

Post a Comment