Exporting selected tables & data

  • 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.

  • Instead of selecting the tables why won't you type the filtering query

  • 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. 

  • 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