how can i download a plain text , csv, etc version of my SQL 2005 database?

Discussion in 'Databases' started by wisemx, Jan 18, 2008.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. wisemx

    wisemx

    I think you'll need to write a code page to do it.
    Which is a standard practice on remote servers.

    Another method, which I've used for years, is to import your remote data then export it locally as comma delimited CSV.
    That is also a method I used for remote Oracle to local SQL Server, and it worked very well.
     
    wisemx, Jan 18, 2008
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    also consider using SQL Import / Export Wizard which is part fo the function of SQL Management studio.


    You can export the table and set the destination to a CSV file.


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Jan 18, 2008
    #2
  3. realized

    realized

    Is there an easy way to do this? What software do i need?

    I have searched and found nothing. And doens't appear to be able to from my control panel either. I can justs create the .bak files.
     
    realized, Jan 18, 2008
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page