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 |
|
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. |
 |
|
|
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. |
|
|
|
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. |
|
|
|
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. |
|
|
|
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 |
|
|
|
juanetes
Starting Member
8 Posts |
Posted - 2011-01-25 : 16:03:58
|
| Thanks! I already solved it by using export/import wizard functionality |
|
|
|
|
|
|
Copying tables to local disk