[AccessD] Re: Upsize wizard in A2K

Mark,

It should be able to do it.  It maybe the setting for DRI on teh SQL Server 
side that is causing the problem.  I have not used the wizard in a long 
time because of the way it names things and the amount of fixing I have to 
do after it does its thing.  I prefer to get in there and get the foreign 
key, constraints, and so on named to a specific convention.  I use ERWin to 
move the structure from Access to SQL Server, Oracle, etc.  It is a high 
end entity relationship modeling tool.

If you want, send the empty database to me and I can reverse engineer it 
into ERWin and send you the DDL for SQL Server for it.

Robert

At 11:24 AM 10/21/2003 -0500, you wrote:
>Date: Tue, 21 Oct 2003 10:07:48 -0500
>From: "Mark Whittinghill" <mwhittinghill at symphonyinfo.com>
>Subject: [AccessD] Upsize wizard in A2K
>To: <accessd at databaseadvisors.com>
>Message-ID: <006d01c397e5$17d8e060$2501a8c0 at PASCAL>
>Content-Type: text/plain;       charset="iso-8859-1"
>
>Hi all,
>
>    I am using the A2K upsize wizard to SQL Server 2000.  It won't let me
>upsize cascade deletes in relationships, though SQL Server 2000 has that.
>I'm using SP-3 of Office 2K.  Is there anything I can do to upsize these, or
>do I need to reset those manually after upsizing.  If so, does A2002 upsize
>cascade deletes?
>
>Thanks
>
>Mark Whittinghill
>Symphony Information Services
>763-391-7400
>mwhittinghill at symphonyinfo.com