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 |
|
anonymowho
Starting Member
3 Posts |
 Posted - 2011-03-04 : 15:02:21
|
| Hi, There are about 15 tables on our SQL server with data in them. I wanted to get a copy of the schema and the data for these 15 tables to my local database on my machine so I can play around offline.I have created the schema on my machine for these 15 tables but I am not sure how to get the data from these 15 tables into my local DB |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
anonymowho
Starting Member
3 Posts |
Posted - 2011-03-04 : 15:18:45
|
| Thanks, using the import export utility I was able to copy over all the data. But I was wondering, is there an easy way to copy the schema for these 15 tables over to my local machine? Import Export utility only copied the data not the schema. In my original post, when I said I was successfully able to copy the schema to my local machine, I did it one by one for all the 15 tables. Not sure if there is an easier way to copy schema. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Copying data from server to local db