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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 HOW TO COPY THE TABLES?

Author  Topic 

tvspsekhar
Starting Member

20 Posts

Posted - 2010-03-18 : 07:04:22
Please help me in copying the tables already created so as to load the same table in another computer and to work.

Ie I have created the tables and inserted all the data in my LAPTOP. Now as I have to load the same table in another DESKTOP PC and to work on the already created table in laptop.

So please help me transferring the data from laptop to PC.
What will be the procedure?
I am not able to copy the dbo.towers (created in laptop) to my pen- drive.

tvspsekhar

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-03-18 : 07:09:06
maybe backup and restore?


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-03-18 : 07:38:19
but this will resote whole database
and if you want to transfer only one table then go by generating script with data scripting from the object explorer.

Vaibhav T
Go to Top of Page
   

- Advertisement -