Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    41

    Question Unanswered: Any script to generate INSERT Statements?

    I need to move some data from a test server to a production server.

    Is there any useful script that I can use to automatically generate INSERT statements for each table that I need to move to production?

    I don't really like to use a tool like bcp as I'll be inserting some data to critical tables and seeing individual INSERT statements makes me more comfortable.

    Any advice is appreciated.

    Thanks

  2. #2
    Join Date
    Dec 2003
    Location
    FRANCE (Paris)
    Posts
    23
    Hi,

    No useful tool exist's, like for MS SQL Server to automaticaly generate insert statement.
    I use this kind of script :

    SELECT 'insert into CNSFRA..TypeTVA (Code,Libelle,CodeORFI) values ('''+RTRIM(Code)+''', ',''''+RTRIM(Libelle)+''',',''''+RTRIM(CodeORFI)+' '')' FROM TypeTVA

    You should pay attention with ''.

    Mickael

Posting Permissions

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