Hi, Thanks for the replies. I was converting using the SQL Servers Import and Export. I found this ....
http://www.web-hosting.com/support/nt/access-to-sql.html And did it through access's upsizing wizard and it come out fine Thanks again ----- Original Message ----- From: "Matthew Friedman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, July 28, 2002 5:11 PM Subject: RE: Convertnig MS Access database to SQL server > When you use the upsizing wizard you can define each field. > > So make sure that you are telling the SQL that you want the Access PK to be > PK. > > matt > > -----Original Message----- > From: Ewok [mailto:[EMAIL PROTECTED]] > Sent: Sunday, July 28, 2002 4:48 PM > To: CF-Talk > Subject: Convertnig MS Access database to SQL server > > > Hi me again :) > > > > I just converted an access database to SQL server for the first time. I had > all the primary keys set to autonumber's (no duplicates) in access but when > I converted to SQL server it simply made them Int's. > > > > I had to go through and set each table's primary key to identity. Is there > something I'm missing that will do this for me when I convert so I don't > have to manually set them every time or should I write some code to get the > max id of the primary key and increment it before I insert the new row? > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
