-
May 13th, 2009, 05:00 AM
#1
Thread Starter
PowerPoster
Copy ms sql table with data
Hi All,
I want to copy a microsoft sql database table from one database to another with the all data. And also those two databases are located in two PCs.
Can anyone help me to do this.
Thanks
“victory breeds hatred, the defeated live in pain; happily the peaceful live giving up victory and defeat” - Gautama Buddha
-
May 13th, 2009, 05:46 PM
#2
Re: Copy ms sql table with data
You can use DTS for this if it is SQL Server 2000.
-
May 14th, 2009, 03:38 AM
#3
Thread Starter
PowerPoster
Re: Copy ms sql table with data
Thanks for the response. Actually it's sql 2005 express edition.
“victory breeds hatred, the defeated live in pain; happily the peaceful live giving up victory and defeat” - Gautama Buddha
-
May 14th, 2009, 07:03 AM
#4
Re: Copy ms sql table with data
You will need to create a linked server then you can copy using a select into statement
Sometimes the Programmer
Sometimes the DBA
Mazz1
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|