Post reply

How can I export a DB data into a delimited format?

  • July 7, 2004 at 8:33 am

    #152216

    Hi,

    For Exporting data, Do I need special tools? (If so name me some) - I need to transfer the data from one application to another

    What query can get me all the table names and field names - in a Database that I am not familier with?

    Thanks

  • July 7, 2004 at 8:53 am

    #513668

    You can use DTS (Data Transformation Services), which is part of SQL Server.  Using Enterprise Manager, navigate to the database you need to export from and click menu option: Tools/Data Transformation Services/Export Data.  This will bring up the Export Data wizard.  You can save as a DTS package for re-execution later.

    Another way to get the wizard up is to go Start/Programs/Microsoft SQL Server/Import and Export Data.

     

    When in doubt - test, test, test!

    Wayne

  • July 8, 2004 at 4:28 am

    #513815

    For Exporting data, Do I need special tools? (If so name me some) - I need to transfer the data from one application to another

    One springs to mind: bcp ( see in BOL )

    This can be useful if you cannot move the data over the network,

    otherwise DTS is a more userfriendly option.

    What query can get me all the table names and field names - in a Database that I am not familier with?

    Variuos: lookup INFORMATION_SCHEMA in BOL

    SELECT * FROM INFORMATION_SCHEMA.TABLES

    SELECT * FROM INFORMATION_SCHEMA.COLUMNS

    /rockmoose


    You must unlearn what You have learnt

  • July 8, 2004 at 11:05 pm

    #513969

    http://www.nigelrivett.net/

    Take a look at the scripts here.  He's got several related to your post.

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply