[AccessD] Re: Upsize wizard in A2K

The DRI looks fine to me on the SQL Server side.  I only upsized the table
structure and am using DTS to import the data.  This is kind of a one-off,
so it's quicker to finish it manually with what I know.  Thanks for the
offer, but I already have the structure done and am in the middle of the
imports.  I'll look into ERWin, though, cuz I'm going to be doing more of
this in the future.

Mark Whittinghill
Symphony Information Services
763-391-7400
mwhittinghill at symphonyinfo.com
----- Original Message ----- 
From: "Robert L. Stewart" <rl_stewart at highstream.net>
To: <accessd at databaseadvisors.com>
Cc: <mwhittinghill at symphonyinfo.com>
Sent: Tuesday, October 21, 2003 1:13 PM
Subject: [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
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>