can someone point me to an AdventureWorks instance that actually can be imported

  • I've got SS 2008 R2 (developer vs I think) and 2014 Express loaded on my machine.

    I'm trying to load the Adventureworks 2008 RS info I downloaded from Codeplex, but keep getting errors.

    When trying to load into 2008 RS, it says the data is a later version (661) than what the database can handle (612).

    When trying to load into 2014 Express, by restoring a backup, it says the database is incorrectly formed.

    Thanks, any help much appreciated.

  • It may be because AdventureWorks has some Enterprise-level features in it, and you are attempting to restore on Express edition. You can use this link for a script to create the database and objects and import the data from CSV files, and this one for instructions on how to do it. The instructions are actually for the AdventureWorks DW, but you should be able to work out how to do it.

    John

  • DSNOSPAM (4/19/2016)


    I've got SS 2008 R2 (developer vs I think) and 2014 Express loaded on my machine.

    I'm trying to load the Adventureworks 2008 RS info I downloaded from Codeplex, but keep getting errors.

    When trying to load into 2008 RS, it says the data is a later version (661) than what the database can handle (612).

    When trying to load into 2014 Express, by restoring a backup, it says the database is incorrectly formed.

    Thanks, any help much appreciated.

    Can you post the full error message, including error codes, for the 2014 error?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • John Mitchell-245523 (4/19/2016)


    It may be because AdventureWorks has some Enterprise-level features in it, and you are attempting to restore on Express edition. You can use this link for a script to create the database and objects and import the data from CSV files, and this one for instructions on how to do it. The instructions are actually for the AdventureWorks DW, but you should be able to work out how to do it.

    John

    AdventureWorks can be installed without problems on an Express edition. I would say that now that Developer edition (starting on 2014) is free, it would be a good idea to upgrade.

    That being said, can you run SELECT @@VERSION from both of your instances and post the results here?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • I've got that script, trying to run it. I have run SQLCMD since 1988!

    I created a new query, went to the Query menu choice, and clicked SQLCMD Mode.

    It gave no indication that anything changed.

    When I run the code, I get:

    A fatal scripting error occurred.

    Variable SqlSamplesSourceDataPath is not defined.

    It does not allow me to jump to the offending line.

    The setvar commands are uncommented, i.e. I removed the :

  • version is:

    Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 10 2010 10:56:29 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.1 (Build 7601: Service Pack 1)

    I've deleted that connection (didn't know I still had 2005 on there)

    and now I get this:

    Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

  • I can see SQL Server 2014 in my programs list, but can't seem to find an instance of it to connect to from SSMS

  • DSNOSPAM (4/19/2016)


    version is:

    Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 10 2010 10:56:29 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.1 (Build 7601: Service Pack 1)

    I've deleted that connection (didn't know I still had 2005 on there)

    and now I get this:

    Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

    For the 2008 instance, are you downloading and following the instructions from here: http://msftdbprodsamples.codeplex.com/releases/view/59211?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • DSNOSPAM (4/19/2016)


    version is:

    Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 10 2010 10:56:29 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.1 (Build 7601: Service Pack 1)

    I've deleted that connection (didn't know I still had 2005 on there)

    and now I get this:

    Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

    Have a look in your list of Services & you should be able to get the 2014 instance name from there. Once you have the instance name, connect to it by specifying [machine name]\[instance name] as the instance you wish to connect to.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • DSNOSPAM (4/19/2016)


    I can see SQL Server 2014 in my programs list, but can't seem to find an instance of it to connect to from SSMS

    Check the services (in Administrative Tools) to be sure that you have the engine installed.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • Sorry for being such a doofus on this. Only place I know to go look at services is under the Task Manager window after hitting CTL ALT DEL.

    I've looked in the menu and icons for SSMS and see nothing that says Administrative tools or services.

    I've not run into these issues before.

  • DSNOSPAM (4/19/2016)


    Sorry for being such a doofus on this. Only place I know to go look at services is under the Task Manager window after hitting CTL ALT DEL.

    I've looked in the menu and icons for SSMS and see nothing that says Administrative tools or services.

    I've not run into these issues before.

    Hit Start and type Services.msc, then Enter.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • Ok, went to control panel, found administrative tools, found servers, but nothing is giving me any version numbers.

    Trying to get an image or a list to post.

  • DSNOSPAM (4/19/2016)


    Ok, went to control panel, found administrative tools, found servers, but nothing is giving me any version numbers.

    Trying to get an image or a list to post.

    Services, not servers.

    You're not looking for version numbers.

    Scroll down the list of Names until you find services which start with the text 'SQL Server'.

    The text in brackets after SQL Server is the instance name. MSSQLSERVER is the default local instance name.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • SQL Server (MSSQLSERVER)Provides storage, processing and controlled access of data, and rapid transaction processing.StartedAutomaticLocal System

    SQL Server (SQLEXPRESS)Provides storage, processing and controlled access of data and rapid transaction processing.StartedAutomaticNetwork Service

    SQL Server Active Directory HelperEnables integration with Active Directories.DisabledNetwork Service

    SQL Server Agent (MSSQLSERVER)Executes jobs, monitors SQL Server, fires alerts, and allows automation of some administrative tasks.ManualLocal System

    SQL Server Analysis Services (MSSQLSERVER)Supplies online analytical processing (OLAP) and data mining functionality for business intelligence applications.StartedAutomaticLocal System

    SQL Server BrowserProvides SQL Server connection information to client computers.DisabledLocal Service

    SQL Server Integration Services 10.0Provides management support for SSIS package storage and execution.StartedAutomaticLocal System

    SQL Server Reporting Services (MSSQLSERVER)Manages, executes, renders, schedules and delivers reports.StartedAutomaticLocal System

    SQL Server VSS WriterProvides the interface to backup/restore Microsoft SQL server through the Windows VSS infrastructure.StartedAutomaticLocal System

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply