Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Product Lifecycle
  3. Free Tools
  4. Data Script Writer -- Tool to generate Insert/Update/Delete scripts from SQL Server Database

Data Script Writer -- Tool to generate Insert/Update/Delete scripts from SQL Server Database

Scheduled Pinned Locked Moved Free Tools
databasesql-serverannouncementcomsysadmin
2 Posts 2 Posters 8 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • D Offline
    D Offline
    Deepak Vasudevan
    wrote on last edited by
    #1

    Hitherto we used to generate the insert scripts through SSMS -> Tasks -> and then Generate Scripts. However the catch is that there is a need for manual intervention when moving these scripts across servers and between version deployments. Hence when trying to get assistance in one of my recent engagements I got to know about this OpenSource tool called DataScriptWriter which is an opensource one at-> GitHub: Where the world builds software · GitHub[^] The things I liked in it: 1) Modes to manage data like Merge (Insert/Delete/Update) using CTE 2) DevExpress Community Library There were a few unhandled exceptions and limitations where the output being saved. Just thought of doing a bit of fix and submitted the same and the author helped to accept the Pull Request.

    E 1 Reply Last reply
    0
    • D Deepak Vasudevan

      Hitherto we used to generate the insert scripts through SSMS -> Tasks -> and then Generate Scripts. However the catch is that there is a need for manual intervention when moving these scripts across servers and between version deployments. Hence when trying to get assistance in one of my recent engagements I got to know about this OpenSource tool called DataScriptWriter which is an opensource one at-> GitHub: Where the world builds software · GitHub[^] The things I liked in it: 1) Modes to manage data like Merge (Insert/Delete/Update) using CTE 2) DevExpress Community Library There were a few unhandled exceptions and limitations where the output being saved. Just thought of doing a bit of fix and submitted the same and the author helped to accept the Pull Request.

      E Offline
      E Offline
      Ebenzer Hamilton
      wrote on last edited by
      #2

      Great content. It's really informative. Thanks you

      Convert PDF to JPG • Decimal to Binary
      https://convertertogenerator.com/
      get online free Converter

      https://cablesport.net/
      https://howtodiscuss.com/
      Through these sites you can share your thoughts with everyone and ask if you want to know about. These two sites will further enhance your general knowledge. you can also connected with others for free

      1 Reply Last reply
      0
      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      • Login

      • Don't have an account? Register

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • World
      • Users
      • Groups