Hey all,

I'm currently using a shopping cart software called .netCart, which is in
ASP.NET and VB. I have been trying to import my local "fully working"
database to my remote server, but then the exported remote database is not
working with the software. Unfortunately, I have no prior experiences in MS
SQL database at all, nor do I know anything about the scripts they used with
the software I purchased.

Error message when attempting to run part of the software (website) with the
exported database -

"Cannot insert the value NULL into column 'CustomerID', table
'tablename.dbo.Customers'; column does not allow nulls. INSERT fails. The
statement has been terminated. [Customer Table]"

I simply used the DTS wizard to export the database. All settings are left
"default" because I don't know what I should do about them....

1) At Specify Table Copy or Quert, "Copy table(s) and view(s) from the
source database is selected.
2) Selected all tables. At the "Column Mappings and Transformations" window
for all tables, "Create detination table" is SELECTED and "Enable identify
insert" is UNCHECKED.
3) At one of the error table (i.e. Customers), the CustomerID int is NOT NULL.

Sorry, I do not know what's wrong with it, and I don't know how to explain
it better technically. The software company do not support this as well.

I believe the problem is with the settings in the DTS wizard when I try to
export the database. Something is not set right, but I don't know how to do
it.

Can anyone please try to solve this problem for me? Thank you very much.

Temjin

In your destination database the column CustomerID in dbo.Customers expects a
value and you are not supplying one.

In the DTS package/wizard instead of executing it there and then why not
save it to sql server and open it up and have a look?


Also why not use BACKUP and RESTORE?




"Temjin" wrote:

Hello,

Doh, I never thought about backing up and restoring it. It works locally.
Now I just have to wait for my hosting provider to use my backup file and
restore my database.

I don't really like this method though as it requires intervention from the
hosting provider everytime I want to update anything to my remote database. I
wanted to use DTS as it is simpler, but it doesn't work (at least the
settings).

Is there any other way, like an easy web adminstration that can do this for
me?

Thanks

Regards,

Temjin

"Allan Mitchell" wrote:

Have you tried enabling IDENTITY INSERT?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Temjin" <Temjin (AT) discussions (DOT) microsoft.com> wrote