Error when exporting SQL Server database to another Server

Asked

Viewed 249 times

2

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

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

inserir a descrição da imagem aqui

inserir a descrição da imagem aqui

I’m thinking the error happens when converting 'datetime' fields to 'smalldatetime'

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

inserir a descrição da imagem aqui

And when I export the bank and click on preview of how it will be after exported the format is like this:

inserir a descrição da imagem aqui

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

database sql-server windows

  • I’ll put it as a comment because I don’t know if it would give a good answer. But I’ve had this problem. And to solve I exported the data from the database to an excel spreadsheet and then imported the data from the spreadsheet to another server. That way it works more smoothly. I don’t know if it would help you, but it wouldn’t hurt to try.

1 answer

2


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

Imagem002

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

Browser other questions tagged database sql-server windows

You are not signed in. Login or sign up in order to post.