Error exporting SQL Server database to another server

Question

Error exporting SQL Server database to another server

Navigation

#1 by (2 votes)

2

I have a database on a SQL Server Web Edition (64-bit) (11.0.5556.0) server and need to export it to a server with SQL Server Express Edition with Advanced Services (64-bit) (10.50.4297.0).

When exporting the data using the SQL Server Export and Import Wizard it encounters the following error:

I'm finding that the error happens when converting 'datetime' fields to 'smalldatetime'

The date format in the error field (LastLockoutDate) is this:

AndwhenIexportthebankandclickonpreviewofhowitwillbeafterexportingtheformatlookslikethis:

If you need any more information, please comment below, I'll edit the question.

sql-server windows

asked by anonymous 13.02.2015 / 15:31

1 answer

Authorization Return NFE 3.10 (MG) C # How to handle a Fatal Error

score 2 · Accepted Answer

What I can suggest would be to edit the mappings during the import and export wizard from the sql server.

You can change the field type, or have it regenerate the table, which I believe will consequently generate with the type of field you need and with the properties defined in the source database.