RE: How to create a data load script from existing DB data

From: Thomas (Thomas_at_discussions.microsoft.com)
Date: 07/29/04 

Date: Thu, 29 Jul 2004 01:59:16 -0700

Hi Frank,

Use http://www.sqlscripter.com to script your data.
You can not only create INSERT scripts, but also UPDATE and DELETE and combinations of them.

It's easy to use and free.
Thomas

 

"Frank" wrote:

> The enterprise manager has the ability to generate a script of the schema for my database, but I can't find any facility to generate a script of the current data.
>
> I will also need to modify any such script to only back up certain rows of each table. My database contains multiple "application definitions" and I basically need to 'backup' and 'restore' the data for any specified "application" instance. Every table has an "application ID" column so this should be easy.
>
> Seems like there should be some generic way to generate a dataload script that I could then modify. Any suggestions?
>
> Thanks,
> -- Frank

Relevant Pages

  • Re: Modifying a record field value while not blocking it to others
    ... And of course again the record you are trying to modify has not to be 'open' ... someone opens that ID=12 record everything in it is locked. ... often add a script line which opens a random record if the file holds enough ... system where customers use Credits when renting items and get Credits ...
    (comp.databases.filemaker)
  • Re: modifying objects in ADAM ADSIEDIT
    ... which is the NetBIOS name I referred to. ... ' Prompt for NetBIOS name of object in AD. ... ' Prompt for the attribute to modify. ... How do I script this by just modifying ...
    (microsoft.public.windows.server.scripting)
  • Re: sus office updates
    ... You can modify the registry ... or you can script a change for MSI to add ... my "encrypted" product code for Office 2003 Professional is: ...
    (microsoft.public.sms.tools)
  • Re: Modifying a record field value while not blocking it to others
    ... And of course again the record you are trying to modify has not to be ... someone opens that ID=12 record everything in it is locked. ... often add a script line which opens a random record if the file holds ... system where customers use Credits when renting items and get Credits ...
    (comp.databases.filemaker)
  • Re: How to create a data load script from existing DB data
    ... "Frank" wrote in message ... > The enterprise manager has the ability to generate a script of the schema ... My database contains multiple "application definitions" and I ... that I could then modify. ...
    (microsoft.public.sqlserver.programming)