SQL server - modify table structures
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3

Thread: SQL server - modify table structures

  1. #1
    Join Date
    Mar 1999
    Posts
    4

    SQL server - modify table structures



    I wrote an application that transfers data from a WANG system (DB = Pace) to SQL server. The only problem is that the DB structure changes from time to time and I need to adjust my SQL server tables.

    What I did in Access was : generating a new DB following the new structure on the WANG and compare the old with the new version and transfer data were needed (using DAO 3.5 objects.)

    For one or another reason this method doesn't work properly on the SQL version. (I only want to use SQLOLE, which is a lot faster)


    I was thinking on, using BCP (BulkCoPy), the methods and properties are available but not explained, neither in MSDN, neither in SQL Servers online books.

    IS there somebody that can show me how I have to use BCP in VB?


    Share on Google+

  2. #2
    Join Date
    Mar 1999
    Posts
    4

    SQL server - modify table structures



    I wrote an application that transfers data from a WANG system (DB = Pace) to SQL server. The only problem is that the DB structure changes from time to time and I need to adjust my SQL server tables.

    What I did in Access was : generating a new DB following the new structure on the WANG and compare the old with the new version and transfer data were needed (using DAO 3.5 objects.)

    For one or another reason this method doesn't work properly on the SQL version. (I only want to use SQLOLE, which is a lot faster)


    I was thinking on, using BCP (BulkCoPy), the methods and properties are available but not explained, neither in MSDN, neither in SQL Servers online books.

    IS there somebody that can show me how I have to use BCP in VB?


    Share on Google+

  3. #3
    Join Date
    Jun 1999
    Posts
    42

    Re: SQL server - modify table structures

    Use SQL 7.0, the export, import utilites are great, I already moved tons of data to SQL using this tool Try it, you can download the trial version in the site of SQL in Microsoft
    http://www.microsoft.com/sql/

    Regards


    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Azure Activities Information Page

Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center