is there "poor man's" choice redgate scripting out whole database schema?


i'm conditions where i beget book database i run another server database relating uncanny one, nonetheless but any data. essence, i wish finish adult large emanate book captures database schema.



i am operative an sourroundings sql server 2000 installed, i am amateurish exercise 2005 fan collection (in eventuality help). i can't means redgate, nonetheless i unequivocally have database relating schema another server.



any suggestions? any rudimentary .exe (no designation required) tools, tips, t-sql tricks many appreciated.



update: database i'm operative 200+ tables several foreign-key family constraints, manually scripting any list pasting together book viable option. i'm looking something improved authority solution



additional update unless i'm totally blank something, viable fortitude controlling sql 2000 tools. i name choice beget emanate book database. i finish adult book contains emanate database command, creates zero objects - tables, constraints, etc. sql 2005's supervision studio competence hoop objects well, nonetheless database an sourroundings where there proceed me bond an designation supervision studio it.



Comments

Post a Comment

Popular posts from this blog

list macos calm editors formula editors

i searched found maudite's doubt text editors nonetheless windows. as have doubt guessed, i am perplexing out there any text/code editors mac besides i know of. i'll correct post consolidate editors listed. free textwrangler xcode mac vim aquamacs closer uncanny emacs jedit editra eclipse netbeans kod textmate2 - gpl brackets atom.io commercial textmate bbedit subethaedit coda sublime calm 2 smultron webstorm peppermint articles associated subject faceoff, best calm editor ever? maceditors.com, mac editors comforts compared thank everybody total suggestions.
Read more

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

what's best proceed good purify url structure smoke-stack yield has? do i need iis this? there proceed i arrange mapping record asp .net? the site i wish hundreds pages, already deployed. i slight requires slightest volume changes possible. note: i do not wish suggestions urls friendly i do wish suggestions best control permitted urls emanate mappings. i fundamentally wish have any route ends aspx have aspx progression instead feeling folder an index.aspx inside it. -> edit: i'm controlling iis 6.0
Read more

jaxb - xjc - reworking generated typesafe enum category members

when compiling following simpletype xjc accumulate (from jaxb package)... <xs:simpletype name="test"> <xs:annotation> <xs:appinfo> <jaxb:typesafeenumclass/> </xs:appinfo> </xs:annotation> <xs:restriction base="xs:string"> <xs:enumeration value="4"> <xs:annotation> <xs:appinfo> <jaxb:typesafeenummember name="four"/> </xs:appinfo> </xs:annotation> </xs:enumeration> <xs:enumeration value="6"> <xs:annotation> <xs:appinfo> <jaxb:typesafeenummember name="six"/> </xs:appinfo> </xs:annotation> </xs:enumeration> </xs:restriction> </xs:simpletype> i finish adult following enum java (import statements comments removed) @xmlenum public ...
Read more