December 2, 2010 at 9:06 am
I have been given a word document that has many table schemas. I have been tasked to create a new DB with these many tables.
The structure of the word document looks like this -
Table ESCROW
Specification:
Column NameTypeLengthPrecScale
Actionchar1
loan_numberchar10
escrow_advance_balancemoney819 4
Is there an 'easy way' via a table create script that I can use the word document to create the tables. There are about 300 tables so this would help me allot if I could use the word doc to create my tables.
December 2, 2010 at 12:04 pm
a) Hire an intern or use rentacoder to retype it.
b) copy the content into textpad, and write a regular expression find and replace to put create before table, etc.
c) use textpad to make it a csv, put it in a staging table, and use dynamic sql to get the info out of it necessary to create a table. Alternatievly, have your intern do this, they like this sort of thing 😉
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
December 2, 2010 at 12:52 pm
You could write a parse Script.
match the texts with if statements and write them in another file as you would like them.
It maybe faster than manually typing everything out.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply