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 Administration
 Copying tables to local disk

Author  Topic 

juanetes
Starting Member

8 Posts

Posted - 2011-01-21 : 18:06:35
Hi. It is my first time using SQL. I have been searching for the solution of my problem during hours and I couldn't find anything.

I am using SQL Server Management Studio to connect to a database from which I use just a few tables of the database.
I want to copy these tables to my local disk and start working on my local machine with these tables (just as I am working today but with data on my local disk).

How can I do it?

Any advice would be great!
Thanks in advance

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2011-01-21 : 18:58:00
Do you have SQL installed on your local machine? you can use the import/export wizard to bring them over.



Poor planning on your part does not constitute an emergency on my part.
Go to Top of Page

juanetes
Starting Member

8 Posts

Posted - 2011-01-21 : 19:03:38
I have installed SQL Server Management Studio Express.
I am not sure what is the "import/export wizard" you mention. I am using Windows XP.
Go to Top of Page

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2011-01-21 : 19:36:31
Well...that is a different story.. that version of SMSS doesn't include the import/export wizards.

I think you can create an Access database, connect to the source server via ODBC, and you can possibly use that to pull down data and the upload it to your local instance.

I believe you can use visual studio tools to do this, but would require some additional work. I am not as familiar with the express versions, but I know the wizards aren't there, and importing data from another server is a pain.

Is the source server edition also express? you can see if they will let you get a copy of the database to attach to your local machines instance.




Poor planning on your part does not constitute an emergency on my part.
Go to Top of Page

juanetes
Starting Member

8 Posts

Posted - 2011-01-22 : 18:15:18
Thanks for your answer. I didn't understand very well the idea of connecting through ODBC.
So where I can get that functionality of "import/export wizards"? I would install the necessary software to do it in the easiest and fastest way possible.
Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2011-01-23 : 11:39:02
Just take a backup from the original DB and restore into your local machine.

PBUH

Go to Top of Page

juanetes
Starting Member

8 Posts

Posted - 2011-01-25 : 16:03:58
Thanks! I already solved it by using export/import wizard functionality
Go to Top of Page
   

- Advertisement -