#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Sep 2003
    Posts
    4
    Rep Power
    0

    MSSQL to DBF import/export


    I'm fairly new to MS SQL Server, but I'm looking for someone to point me in the right direction with importing and exporting to a DBF file. Any ideas will be much appreciated.

    I'm trying to create a site in asp/mssql that will replicate data held in local dbf files. Every so often, I need to synchronize the mssql db from the dbf files so the web site shows "live" data. This will mean both importing and exporting.

    Thank you, in advance,

    Andonis
  2. #2
  3. No Profile Picture
    Contributing User
    ASP Discoverer (100 - 499 posts)

    Join Date
    Aug 2003
    Posts
    312
    Rep Power
    16
    what in specif would you like to know? There's many ways to do it, such as snapshots that do it once every x hours, or transactional which will update each time something occurs. The easiest way is just to open the DB in enterprise manager, and run through the wizards they have when you right click on the DB.

    Unfortunately they can also be really finicky, which is why i tend to stick with DTS packages. My advice, look at what you need, then start messing around with it, because there's always something there that makes your situation different and sometimes rough to get working....
  4. #3
  5. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Sep 2003
    Posts
    4
    Rep Power
    0

    dts looks good


    I had a quick look at dts, and managed to bash out a quick import. Thanks for the help unatratnag.

    I don't suppose you know how to execute a dts package from a trigger do you? Are triggers an advisable way to execute a dts package that you don't want to have scheduled?

    Thanks,
  6. #4
  7. No Profile Picture
    Contributing User
    ASP Discoverer (100 - 499 posts)

    Join Date
    Aug 2003
    Posts
    312
    Rep Power
    16
  8. #5
  9. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Sep 2003
    Posts
    4
    Rep Power
    0
    thanks for the help

Similar Threads

  1. Replicate a DB in MSSQL from an ASP Page
    By DesignerDesign in forum ASP Development
    Replies: 0
    Last Post: January 29th, 2004, 10:47 PM
  2. Retrieve and Store Binary files to MSSQL Server
    By jveron23 in forum .NET Development
    Replies: 2
    Last Post: January 15th, 2004, 03:10 PM
  3. problems with mssql connection
    By hell_on_ice in forum .NET Development
    Replies: 6
    Last Post: December 12th, 2003, 02:36 PM
  4. ASP with MS SQL Server to DBF import/export
    By a_zen_s in forum ASP Development
    Replies: 0
    Last Post: September 12th, 2003, 09:26 AM
  5. How to insert files into mssql?
    By Steve Schofield in forum SQL Development
    Replies: 0
    Last Post: July 12th, 2001, 04:26 PM

IMN logo majestic logo threadwatch logo seochat tools logo