MS SQL Server Import - Importing Data With New NON NULL Column

Question

I am trying to import from an old database into an updated one.

The databases are basically identical except in one of my tables I added a new column that is NOT NULL.

This obviously makes errors when I used the importer to move the rows over. Is there a way that I can define a default for this new NOT NULL field when doing an Import?

score 2 · Accepted Answer · edited May 23 '17 at 11:47

2

Yes you can add a default constraint to the new column. See this post: Alter column, add default constraint

alter table TableName
add constraint df_ConstraintNAme
default > getutcdate() for [Date]

edited May 23 '17 at 11:47

Community

1
1

answered Aug 01 '11 at 16:58

Cory

12,404
7
33
28

Surely that will raise an error message like `Msg 102, Level 15, State 1, Line 5 Incorrect syntax near '>'.` If you remove the `>` character, it should work. – Iain Samuel McLean Elder Nov 20 '12 at 11:45

score 0 · Answer 2 · answered Aug 01 '11 at 16:58

0

Two options are:

1) Define a DEFAULT value constraint on the column

2) Temporarily make the column NULL, do the import, then reapply the NOT NULL constraint

answered Aug 01 '11 at 16:58

Joe

41,484
20
104
125

MS SQL Server Import - Importing Data With New NON NULL Column

2 Answers2