Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2002
    Posts
    2

    Unhappy Unanswered: Need a Sql Scriptor

    I need to generate the Sql Scripts for a particular Database in a Sql Server 7.0.

    Also i need help in the Data Migration of Foxpro2.6a to SqlServer.

    If there are any good tools for such conversion,I am very much thankful to all who comes with a good reply.

    Thanks & Regds,
    B.Sethu

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Just right click any of your databases and choose "all tasks" then "generate sql scripts". If you have an odbc driver for the foxpro database then you can use the dts import wizard. If not, just export the foxpro database to a delimited file and use the wizard.

  3. #3
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    To migrate your data look into Distributed Transaction Coordinator (DTS),which comes with SQL Server. Also use Google to research on the migration.
    MCDBA

  4. #4
    Join Date
    Oct 2002
    Posts
    2

    Angry Sql Script Generator

    Thanks for the reply.I need to create Insert Statements for all my Master Tables(say 1000).I need a tool which gives me the insert statements,either if i give the Database or Tables of the Database.

    Also for foxpro we don't have any ODBC driver,moreover my all foxpro tables have memo fields,which i can't transform via DTS.

    Thanks & Regds,
    B.Sethu

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    To generate the scripts for all of your databases you can use the sql-dmo script method - look at your books online.

    What happens when you try to transform the foxpro table with a memo field ?

  6. #6
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    I've created a stored procedure that will generate the INSERT statements

    Example in Pubs database
    Code:
    exec usp_CreateInsert authors
    
    INSERT  authors ( au_id, au_lname, au_fname, phone, address, city, state, zip, contract) 
    VALUES ('409-56-7008','Bennet','Abraham','415 658-9932','6223 Bateman St.','Berkeley','CA','94705',1)
    INSERT  authors ( au_id, au_lname, au_fname, phone, address, city, state, zip, contract) 
    VALUES ('427-17-2319','Dull','Ann','415 836-7128','3410 Blonde St.','Palo Alto','CA','94301',1)
    I've attached the script
    Attached Files Attached Files
    MCDBA

  7. #7
    Join Date
    Feb 2002
    Posts
    2,232
    For the foxpro conversion - have you tried converting to access first then to sql server ?

Posting Permissions

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