Click here to Skip to main content
15,937,002 members
Articles / Database Development / SQL Server / SQL Server 2008
Tip/Trick

MyMDb your local IMDB store

Rate me:
Please Sign up or sign in to vote.
5.00/5 (8 votes)
22 Jul 2013CPOL 63.3K   2.5K   21   30
Want your own movie database??? Download IMDB in 20 minutes.

Introduction

The program will help you to:

  • Create a local DB for Movies and Series
  • Download the data from one of IMDB's Interfaces
  • Synchronize your data

Today (22-07-2013) there where 2.583.953 movies and series

DB Layout

Click here to make large...

Image 1

Using the code

Step 1: Telling the program which SQL Server to use, and test the connection

Image 2

Step 2: Building the local database. If the DB exists you can rebuild it or skip this step.

Image 3

Image 4

Step 3: Choosing the IMDB Interface to download from...

Image 5

Once you have selected the Interface check the files you want to download, and press Download data.

The program will automatically download and decompress the files.

Step 4: Synchronizing your data

Image 6

Points of Interest

If you want to build your own movie database, so you don't have to scrape IMDB all the time, this could give you some idea to how you should go along with it...

History

  • 22-07-2013: First draft posted.
  • TODO: Explain the code.

Download

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer
Denmark Denmark

Comments and Discussions

 
QuestionHow to install ? Pin
Member 118773036-Aug-15 13:02
Member 118773036-Aug-15 13:02 
AnswerRe: How to install ? Pin
Paw Jershauge6-Aug-15 20:41
Paw Jershauge6-Aug-15 20:41 
QuestionDistributor table Pin
Member 112988699-Dec-14 14:50
Member 112988699-Dec-14 14:50 
AnswerRe: Distributor table Pin
Paw Jershauge9-Dec-14 21:18
Paw Jershauge9-Dec-14 21:18 
GeneralRe: Distributor table Pin
Member 1129886918-Dec-14 14:49
Member 1129886918-Dec-14 14:49 
QuestionNew Issue with sync Pin
Member 1124802519-Nov-14 14:13
Member 1124802519-Nov-14 14:13 
AnswerRe: New Issue with sync Pin
Paw Jershauge24-Nov-14 21:16
Paw Jershauge24-Nov-14 21:16 
QuestionThe complete DB Pin
yevgeni18-May-14 1:13
yevgeni18-May-14 1:13 
QuestionDifficulty with database access Pin
James Huebsch23-Jul-13 18:58
James Huebsch23-Jul-13 18:58 
AnswerRe: Difficulty with database access Pin
Paw Jershauge24-Jul-13 0:24
Paw Jershauge24-Jul-13 0:24 
QuestionRe: Difficulty with database access Pin
James Huebsch24-Jul-13 17:12
James Huebsch24-Jul-13 17:12 
AnswerRe: Difficulty with database access Pin
Paw Jershauge24-Jul-13 21:42
Paw Jershauge24-Jul-13 21:42 
GeneralRe: Difficulty with database access Pin
James Huebsch25-Jul-13 4:47
James Huebsch25-Jul-13 4:47 
According to the messages from the build it did not appear to fail. I am using SQL Server 2008 R2 in case that matters. Below is the output from the build.

[7/25/2013 9:35:37 AM] Change script command to master database... Success!
[7/25/2013 9:35:37 AM] Entering Single User Mode, please wait... Success!
[7/25/2013 9:35:37 AM] Remove the MyMDb Database... Success!
[7/25/2013 9:35:37 AM] Create the MyMDb Database... Success!
[7/25/2013 9:35:38 AM] Altering MyMDb Database files... Success!
[7/25/2013 9:36:07 AM] Entering Multi User Mode, please wait... Success!
[7/25/2013 9:36:07 AM] Change script command to new database MyMDb... Success!
[7/25/2013 9:36:07 AM] Create Documentation for the MyMDb database... Success!
[7/25/2013 9:36:07 AM] Change script command to MyMDb database... Success!
[7/25/2013 9:36:07 AM] Remove the imdb schema... Success!
[7/25/2013 9:36:07 AM] Create the imdb schema... Success!
[7/25/2013 9:36:07 AM] Create Documentation for the imdb schema... Success!
[7/25/2013 9:36:07 AM] Change script command to MyMDb database... Success!
[7/25/2013 9:36:07 AM] Remove Genre and its assosicated objects... Success!
[7/25/2013 9:36:07 AM] Create the Genre Table... Success!
[7/25/2013 9:36:07 AM] Create Documentation for the Genre Table... Success!
[7/25/2013 9:36:07 AM] Insert values into the Genre Table... Success!
[7/25/2013 9:36:07 AM] Change script command to MyMDb database... Success!
[7/25/2013 9:36:07 AM] Remove ISO639 and its assosicated objects... Success!
[7/25/2013 9:36:07 AM] Create the ISO639 Table... Success!
[7/25/2013 9:36:07 AM] Create Documentation for the ISO639 Table... Success!
[7/25/2013 9:36:07 AM] Insert values into the ISO639 Table... Success!
[7/25/2013 9:36:09 AM] Change script command to MyMDb database... Success!
[7/25/2013 9:36:09 AM] Remove ISO3166 and its assosicated objects... Success!
[7/25/2013 9:36:09 AM] Create the ISO3166 Table... Success!
[7/25/2013 9:36:09 AM] Create Documentation for the ISO3166 Table... Success!
[7/25/2013 9:36:09 AM] Create IX_Name Index the ISO3166 Table... Success!
[7/25/2013 9:36:09 AM] Create IX_Alpha2 Index the ISO3166 Table... Success!
[7/25/2013 9:36:09 AM] Insert values into the ISO3166 Table... Success!
[7/25/2013 9:36:09 AM] Change script command to MyMDb database... Success!
[7/25/2013 9:36:09 AM] Remove MediaEntry and its assosicated objects... Success!
[7/25/2013 9:36:09 AM] Unknown command... Success!
[7/25/2013 9:36:09 AM] Create the MediaEntry Table... Success!
[7/25/2013 9:36:09 AM] Create Documentation for the MediaEntry Table... Success!
[7/25/2013 9:36:09 AM] Create the IX_Title Index on MediaEntry... Success!
[7/25/2013 9:36:09 AM] Create the IX_Title_SubTitle Index on MediaEntry... Success!
[7/25/2013 9:36:09 AM] Create the IX_Title_Year Index on MediaEntry... Success!
[7/25/2013 9:36:09 AM] Create the IX_Title_Year_Subtitle Index on MediaEntry... Success!
[7/25/2013 9:36:09 AM] Create Documentation for the MediaEntry Indexes... Success!
[7/25/2013 9:36:09 AM] Change script command to MyMDb database... Success!
[7/25/2013 9:36:09 AM] Remove Tagline and its assosicated objects... Success!
[7/25/2013 9:36:09 AM] Create the TagLine Table... Success!
[7/25/2013 9:36:09 AM] Create Documentation for the TagLine Table... Success!
[7/25/2013 9:36:09 AM] Change script command to MyMDb database... Success!
[7/25/2013 9:36:09 AM] Remove Plot and its assosicated objects... Success!
[7/25/2013 9:36:09 AM] Create the Plot Table... Success!
[7/25/2013 9:36:09 AM] Create Documentation for the Plot Table... Success!
[7/25/2013 9:36:09 AM] Change script command to MyMDb database... Success!
[7/25/2013 9:36:09 AM] Remove MediaEntry to Genre Relationship and its assosicated objects... Success!
[7/25/2013 9:36:09 AM] Create the MediaEntry to Genre Relationship Table... Success!
[7/25/2013 9:36:09 AM] Create Documentation for the MediaEntry to Genre Relationship Table... Success!
[7/25/2013 9:36:09 AM] Change script command to MyMDb database... Success!
[7/25/2013 9:36:09 AM] Remove MediaEntry to Genre Relationship and its assosicated objects... Success!
[7/25/2013 9:36:09 AM] Create the MediaEntry to Genre Relationship Table... Success!
[7/25/2013 9:36:09 AM] Create Documentation for the MediaEntry to Genre Relationship Table... Success!
[7/25/2013 9:36:09 AM] Change script command to MyMDb database... Success!
[7/25/2013 9:36:09 AM] Remove CountryCorrection and its assosicated objects... Success!
[7/25/2013 9:36:09 AM] Create the CountryCorrection Table... Success!
[7/25/2013 9:36:09 AM] Create Documentation for the CountryCorrection Table... Success!
[7/25/2013 9:36:09 AM] Insetring known values into the CountryCorrection Table... Success!
[7/25/2013 9:36:09 AM] Change script command to MyMDb database... Success!
[7/25/2013 9:36:09 AM] Remove MergeMediaEntry and its assosicated objects... Success!
[7/25/2013 9:36:09 AM] Create the MergeMediaEntry Procedure... Success!
[7/25/2013 9:36:09 AM] Create Documentation for the MergeMediaEntry Procedure... Success!
[7/25/2013 9:36:09 AM] Remove MergeTagLine and its assosicated objects... Success!
[7/25/2013 9:36:09 AM] Create the MergeTagLine Procedure... Success!
[7/25/2013 9:36:09 AM] Create Documentation for the MergeTagLine Procedure... Success!
[7/25/2013 9:36:09 AM] Remove MergePlots and its assosicated objects... Success!
[7/25/2013 9:36:09 AM] Create the MergeTagLine Procedure... Success!
[7/25/2013 9:36:09 AM] Create Documentation for the MergeTagLine Procedure... Success!
[7/25/2013 9:36:09 AM] Remove MergeGenres and its assosicated objects... Success!
[7/25/2013 9:36:09 AM] Create the MergeTagLine Procedure... Success!
[7/25/2013 9:36:09 AM] Create Documentation for the MergeTagLine Procedure... Success!
[7/25/2013 9:36:09 AM] Remove MergeCountry and its assosicated objects... Success!
[7/25/2013 9:36:09 AM] Create the MergeTagLine Procedure... Success!
[7/25/2013 9:36:09 AM] Create Documentation for the MergeTagLine Procedure... Success!
[7/25/2013 9:36:09 AM] Change script command to MyMDb database... Success!
[7/25/2013 9:36:09 AM] Remove GetTopGenreCount and its assosicated objects... Success!
[7/25/2013 9:36:09 AM] Create the GetTopGenreCount Procedure... Success!
[7/25/2013 9:36:09 AM] Create Documentation for the GetTopGenreCount Procedure... Success!
[7/25/2013 9:36:09 AM] Remove GetTopYearCount and its assosicated objects... Success!
[7/25/2013 9:36:09 AM] Create the GetTopYearCount Procedure... Success!
[7/25/2013 9:36:09 AM] Create Documentation for the GetTopYearCount Procedure... Success!
[7/25/2013 9:36:09 AM] Change script command to MyMDb database... Success!
[7/25/2013 9:36:09 AM] Remove GetMedia and its assosicated objects... Success!
[7/25/2013 9:36:09 AM] Create the GetMedia Procedure... Success!
[7/25/2013 9:36:09 AM] Create Documentation for the GetMedia Procedure... Success!

[7/25/2013 9:36:09 AM] DONE!, your good to go...
James Huebsch

SuggestionRe: Difficulty with database access Pin
Paw Jershauge25-Jul-13 4:55
Paw Jershauge25-Jul-13 4:55 
GeneralRe: Difficulty with database access Pin
James Huebsch25-Jul-13 8:46
James Huebsch25-Jul-13 8:46 
GeneralRe: Difficulty with database access Pin
Paw Jershauge25-Jul-13 8:53
Paw Jershauge25-Jul-13 8:53 
QuestionRe: Difficulty with database access Pin
Paw Jershauge25-Jul-13 4:57
Paw Jershauge25-Jul-13 4:57 
AnswerRe: Difficulty with database access Pin
James Huebsch25-Jul-13 8:49
James Huebsch25-Jul-13 8:49 
GeneralRe: Difficulty with database access Pin
Paw Jershauge25-Jul-13 8:54
Paw Jershauge25-Jul-13 8:54 
BugCrashed Pin
Arsalan Ahmad23-Jul-13 7:49
Arsalan Ahmad23-Jul-13 7:49 
SuggestionRe: Crashed Pin
Arsalan Ahmad23-Jul-13 8:00
Arsalan Ahmad23-Jul-13 8:00 
AnswerRe: Crashed Pin
Paw Jershauge24-Jul-13 0:21
Paw Jershauge24-Jul-13 0:21 
QuestionNice article Pin
B. Clay Shannon23-Jul-13 6:13
professionalB. Clay Shannon23-Jul-13 6:13 
AnswerRe: Nice article Pin
Paw Jershauge23-Jul-13 6:25
Paw Jershauge23-Jul-13 6:25 
GeneralMy vote of 5 Pin
Nisarg S Shah23-Jul-13 1:13
Nisarg S Shah23-Jul-13 1:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.