web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / how to import data of ...
Microsoft Dynamics AX (Archived)

how to import data of a table from backup

(0) ShareShare
ReportReport
Posted on by Lakshmi Karambakkam 1,307

Hi,

i did a data backup of the database and model store. I had to drop and create a table due to fieldID mismatch error.

Illegal data conversion from original field KANBANJOB.QUEUETIMEBEFORE to KANBANJOB.QueueTimeBeforeUnit: Unable to convert data types to anything but character field type (1 to 49).

How to import data back to the table?

Thanks,

lakshmi

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Rustem Galiamov Profile Picture
    Rustem Galiamov 8,072 on at

    Hi!

    If you have DB which contains the data you can use import/export tool inside management studio.

  • Lakshmi Karambakkam Profile Picture
    Lakshmi Karambakkam 1,307 on at

    could you explain me in step by step process or any documentation that gives me a step by step way to import data?

    Especially where and how to specify the backup file of my database?

    Thanks,

    Lakshmi

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    I would look into the SQL server documentation. Also be sure to restore your backup to a new database, not in your current one (or you will overwrite it). After restore you will have the current and the old db side by side and you can copy between them.

    docs.microsoft.com/.../back-up-and-restore-of-sql-server-databases

    How did this field id problem appear in the first place? I would say the best process in such scenario is to restore from backups immediately and figure out another way to do what you were doing.

  • Verified answer
    Rustem Galiamov Profile Picture
    Rustem Galiamov 8,072 on at

    This link will be helpful : https://www.sqlshack.com/how-to-copy-tables-from-one-database-to-another-in-sql-server/

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 21

#2
dekion Profile Picture

dekion 4

#2
Virginia99 Profile Picture

Virginia99 4

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans