May 10, 2006 at 12:17 am
SQL 2000. Sorry for being such a noob, but I've only been in the SQL environment for a couple of months now (the deep end). I need to export selected tables and their data to another, off-site, SQL database and was wondering how to do it.
I think I managed to get the whole table & field creation issue working. I selected the tables I needed to exported, right-click, All Tasks, Generate SQL script then OK'd the form with the default options. It created a SQL file which looks healthy.
Is there a simple way of now exporting the data from the same tables without taking the whole lot? If so, pls tell me how.
May 10, 2006 at 3:05 am
Instead of selecting the tables why won't you type the filtering query
May 11, 2006 at 6:37 am
Have you thought about using a DTS package to accomplish this? Try going to 'Tools' -> 'Data Transformation Services' -> 'Export Data' and go through the wizard to create your package.
May 11, 2006 at 9:20 am
DTS can copy your table schema as well as data. That would eliminate your scripting step.
Greg
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply