Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
boreddy
Posting Yak Master
172 Posts |
 Posted - 2008-10-20 : 01:23:12
|
| How can we move table and the date from one server to another server trow scripts( with out useing omport and export)please give reply thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-20 : 01:32:36
|
| table and date? what do you mean by that? do you mean transfering contents of date column in a table? |
 |
|
|
boreddy
Posting Yak Master
172 Posts |
Posted - 2008-10-20 : 01:35:07
|
| I mean that i should have to move table structure and that table contained data |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-20 : 01:45:08
|
quote:
Originally posted by boreddy
I mean that i should have to move table structure and that table contained data
Script out table from enterpise manager/sql management studio. apply the script to other server to create the table.To transfer data, use OPENROWSET() to move data from first server to other, look into books online for syntax and usage of OPENROWSET() |
|
|
|
|
|
|
how can we do like this