Hi Mark, I am in exactly the same situation as you. Like you I am more familiar with Access so I do my database design work there and use the Upsizing Wizard in Access (Tools-Database Utilities-Upsizing Wizard) to convert the database to SQL. It's not elegant but works well and will do until I know SQL better. The conversion handles primary keys with an AutoNumber datatype just fine. For example: It converted a primary key autonumber (with a Field Size of Long Integer and a New Value of Increment) to an int, length 4, Identity =Yes, Identity Seed=1, Identity Increment =1. Hope this helps.
Respectfully, Dan Nall -----Original Message----- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: Thursday, February 10, 2005 10:19 AM To: [email protected] Subject: [plum] sql views and plum I just purchased and installed sql 2000 so I could do the Plum tutorials. I have been using ms access for quite some time and I am comfortable with it and the IDE. However, sql 2000 looks like a beast. I have managed to figure out how to use the enterprise manager (sort of) and have imported a previously completed database from access. I have some real newbie questions for anyone out there who feels so inclined: 1. What do I use in place of autoNumber for primary key values? Is there a way to preserve the primary key on import and change the field type automatically? It seems like all my tables have varchar30 values and no primary key where the autoNumber fields were. 2. Can Plum use a view just like it does a table? I think I read that somewhere in the help but a search today did not prove fruitful. Access does not support views and that is the primary reason I wanted to start with sql 2k (and the tutorials of course). The project I want to do with Plum has alot of joined tables and without views, it does not seem like the framework would provide me with much (I mean no disrespect). All of my add/edit/delete actions involve multiple tables. 3. Aside from the tutorials, plum supports access. If access does not support views and Plum does, how does plum work that out? 4. If I want to develope in ms access and then import into sql2k, are there things other than autoNumber I should avoid? Forright now, I really do feel alot more comfortable with access. Thanks alot, Mark ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm ********************************************************************** ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm ********************************************************************** ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
