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 |
|
gamaz
Posting Yak Master
104 Posts |
 Posted - 2008-06-23 : 17:59:21
|
| Hi,I got two tables in a rather big sql server database that I need to work on. Is there any command that will allow me to import the two tables to a database in my local server. If I do a select * into temptable from sourcetable it is created in the database of the main server. However I want the table creation in my local server. Any help is appreciated. Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-23 : 18:51:05
|
| Use Export/Import Wizard. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
gamaz
Posting Yak Master
104 Posts |
Posted - 2008-06-24 : 15:13:34
|
| Thanks Sodeep and Tara for the help. I used the export import to do this job. I will try linked server and bcp sometime soon to see how those work.Regards |
|
|
|
|
|
|
How to copy a table from one server to another