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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX 2012 Contoso Demo D...
Microsoft Dynamics AX (Archived)

AX 2012 Contoso Demo Data for SQL Server 2008 not R2

(0) ShareShare
ReportReport
Posted on by Sebastián Tirelli 290

I have seen AX 2012 Featured Pack Contoso bak file for SQL Server 2008 R2 in PartnerSource but none for SQL 2008 not R2, even knowing that AX 2012 works perfectly well on both DBMS.

Does anyone knows how could I upload the data in a safe and correctly way.

I have thought in sql scripts and dat def exports, but they are very expensive, not only in time but in data space.

Please any advice would be great.

Thanks.

*This post is locked for comments

I have the same question (0)
  • Arturo Medina Profile Picture
    Arturo Medina 696 on at

    Sebastián,

    I think the Contoso demo DB [DemoDataAX.mdf] is NOT SQL version specific, provided that you are using a suported SQL version. I deduct this because I recently downloaded and installed the demo DB on a box with SQL Server 2012 (64-bit) SP1.

    The only "minor" surprise was that Help/ About showed: 6.0.947.280 AX2012 Cumulative Update 2. I was expecting 6.0.947.862 AX2012 Feature Pack instead. I haven't went through the Initialization checklist, but so far, so good.

    HTH

    ==

  • Sebastián Tirelli Profile Picture
    Sebastián Tirelli 290 on at

    Hi Arturo, first I would like to thank you the answer.

    As I have seen DemoDataAX is not an mdf file, but instead is a .bak file which is a Backup file. The backups in MS SQL are made from a DBMS like MS SQL 2008 or MS SQL 2008 R2. Then when you want to restore that backup if you don't have the same version where the backups were made you will be in the same situation than me. Just an example: If the .bak file was made in MS SQL 2008 R2 you can restore it in that version , and newer versions like 2012, but never in prior versions.

    More over you can't downgrade the MS SQL from R2 to non R2, and the upgrade in production environments are very difficult.

    The only way I found to solve this is to make sql scripts with the schemas and data but this is way too expensive in space, allocating more than 15GB. The other way is to make dat and def one to one for the companies in Ax.

    What is releventat here is that Ax 2012 works fine (and Microsoft have it in the systems requirements white papers) in SQL 2008 not R2, so it would be very handy for all developers around the world to have a .bak or scripts to use with minor versions than R2.

    Please any support from Microsoft.

    Thanks.

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans