Post reply

How to import SQL SERVER 2000 Database into CSV format

  • June 30, 2008 at 12:40 am

    #70336

    Hi All,

    Please help me.

    I am havin a database in sql server 2000 and we have completed the project but the client is not having sql server, he is havin virtual server and now he wants the whole database in CSV format. I dont have knowledge to import the database in CSV format, Please help me if we can do it.

    Thanks,

    Syed Sanaullah Khadri

    (DBA)

  • June 30, 2008 at 4:24 am

    #836011

    You'll have to export each table individually to a csv file. You can use bcp, you can write a DTS package or you can use the inport/export wizard.

    What does the client intend to do with the csv? Virtual server is not a database product.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 30, 2008 at 5:16 am

    #836021

    Hi,

    I dont know what client will do but he said to give csv format. Thanks for the support. It will help me to learn new concept.

  • July 1, 2008 at 1:51 am

    #836477

    [font="Verdana"]Hi,

    You can't export the entire database in csv format. You can only export table details in CSV format. To import csv format I hope can use import \ export wizard available in SQL 2000.[/font]

    Regards..Vidhya Sagar
    SQL-Articles

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

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