Posted by NickName on 10/02/29 11:51

Thanks, unintended regression for a minute (forgot the Advance search
option).
I've found some pattern of the intersection/link tables in the Access
db and based on that created a script to add FKs/relationships for the
tables, missed one or two (which can easily be handled by hand). So,
in other words, I have one script to address PKs/Indexes and another
for FKs, but of course they can be just one.

Now, as for the modules and queries (Access), I guess, they are messy
parts, would have to convert them probably one by one into either SPs
or UDFs.

Erland Sommarskog wrote:
> NickName (dadada@rock.com) writes:
> > Thanks. Would be interested in reading M. Chipman's writings on "don't
> > use the wizard", did key word search for it to no avail.
>
> I went to http://groups.google.com/advanced_group_search and for
> exact phrase I filled in "upsizing wizard" and for author I specified
> "Mary Chipman", and I opted to get 100 hits per page. Next I pressed Search.
> I got 189 hits.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]