Click here to Skip to main content
15,944,390 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.4K   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 
How can I get the complete imdb database, including grades?
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 
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.