Inserting Missing Data into Adventure Works 2014

  • Thread starter Thread starter WWGD
  • Start date Start date
  • Tags Tags
    Data Sql Works
Click For Summary
The AdventureWorks2014 database copy is missing data despite having the schema, including tables and indexes. The issue may stem from a problem with the SQL Server rather than any user operations like delete, truncate, or drop. A user seeks solutions to insert the missing data without resorting to dropping and restoring the entire database. Potential solutions could involve using backup files, scripts, or data import methods to recover the missing information.
WWGD
Science Advisor
Homework Helper
Messages
7,772
Reaction score
13,008
Hi All,
Somehow the copy of AdventureWorks2014 I downloaded ( saved and restored) is missing the data,
i.e., it contains the schema : tables, indexes, etc. , but many tables are missing the actual data. I have
not done any delete/truncate/drop operations, so this may have been a problem with my SQL Server.
Short of dropping the whole database and restoring it, is there a way of inserting the missing data?
Thanks.
 
Thread 'ChatGPT Examples, Good and Bad'

Thread 'ChatGPT Examples, Good and Bad'

I've been experimenting with ChatGPT. Some results are good, some very very bad. I think examples can help expose the properties of this AI. Maybe you can post some of your favorite examples and tell us what they reveal about the properties of this AI. (I had problems with copy/paste of text and formatting, so I'm posting my examples as screen shots. That is a promising start. :smile: But then I provided values V=1, R1=1, R2=2, R3=3 and asked for the value of I. At first, it said...
View full post »

Similar threads

Copying Databases between Different Versions of SQL Server
  • · Replies 8 ·
Replies
8
Views
2K
Why can't there be a Database tool that has the best of everything?
  • · Replies 5 ·
Replies
5
Views
2K
Why are tables not showing up in Object explorer in database
  • · Replies 5 ·
Replies
5
Views
7K
Need resources for ER diagram and SQL
  • · Replies 5 ·
Replies
5
Views
2K
Book Review: Invisible Women: Data Bias in a World Designed for Men
  • · Replies 19 ·
Replies
19
Views
8K
Java Android Studio: Accessing SQLite Data In RecyclerView
  • · Replies 1 ·
Replies
1
Views
4K
High School Infrared Detectors & The 2nd Law of Thermodynamics
  • · Replies 152 ·
6
Replies
152
Views
10K
Requesting suggestions for languages, libraries, and architectures for parallel (and sometimes non parallel) numerical and scientific computations
  • · Replies 8 ·
Replies
8
Views
4K
Is Consciousness Merely a Product of Determinism in a Logical Universe?
  • · Replies 3 ·
Replies
3
Views
6K
Mathematica This Week's Finds in Mathematical Physics (Week 242)
  • · Replies 1 ·
Replies
1
Views
3K