When you moved your data in SQL Server. You exported tables which doesn't copy the IDENTITY column settings over. The ID column will not have an identity, seed or increment set it will also not be set as the primary key.
When you move data from one DB to the another you need to Copy Objects not copy tables. That way the constraints, defaults and such get copied as well. You do need admin permissions on both DB's to do this which is why copying tables is easier. You will have to reset the IDENTITY COLUMN values by hand based on the MAX current ID. Or strip the table sout and export them again. A simpler solution can be to detach the DB. Copy the MDF and LDF files and re-attach the files at both ends. That way you get an exact copy of the DB. regards Steve Alistair Davidson <[EMAIL PROTECTED]> wrote : > Is report_id set as the identity column in your old server? Make sure > it's still set as identity in the new one. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > > Sent: 06 July 2004 11:35 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] SOT - SQL > > I have just moved an SQL database from one server to another. I have > setup > all of the connections in MX administrator all OK and everything worked > fine. > However the backend admin system is another story :( > > I am trying to add data to the database and get the following error. > > [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot insert the value > NULL into column > 'Report_ID', table 'schools_performance.dbo.Report_Names'; column does > not allow nulls. > INSERT fails. > > The data trying to be inserted according to the error page is ... > > INSERT INTO Report_Names (report_name, path_name, Doc_Type_ID) VALUES > ('summer reports', 'summer', '3') > SELECT @@IDENTITY AS 'last_record_ID' > DATASOURCE WebUserDSN > > I still have the database & code on the old server and all works fine > there. > > I imported the data from the old server to the new server. All appears > to be the same .... > > Any ideas? > > Regards - Paul > > > > > ************************************************************************ > ************************* > The information contained within this e-mail (and any attachment) sent > by Birmingham City Council is confidential and may be legally > privileged. It is intended only for the named recipient or entity to > whom it is addressed. If you are not the intended recipient please > accept our apologies and notify the sender immediately, or telephone > +(44) 121 303 6666. Unauthorised access, use, disclosure, storage or > copying is not permitted and may be unlawful. Any e-mail including its > content may be monitored and used by Birmingham City Council for reasons > of security and for monitoring internal compliance with the office > policy on staff use. E-mail blocking software may also be used. Any > views or opinions presented are solely those of the originator and do > not necessarily represent those of Birmingham City Council. We cannot > guarantee that this message or any attachment is virus free or has not > been intercepted and amended. > ************************************************************************ > ************************* > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF > provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by > activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] Steve Powell [EMAIL PROTECTED] 07971 583792 -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
