Click here to Skip to main content
15,937,239 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 
I am trying to sync. I tried all the things that is written. But I get this all the time cos of stored procedure.
CSS
Prepare SQL Server for Operations...
[20.11.2014 03:08:27]   Change script command to MyMDb database... Success!
[20.11.2014 03:08:27]   Preparing the bulk tables... Success!

[20.11.2014 03:08:27]   Movies are being processed, please wait...

[20.11.2014 03:11:59]   Data has been send to the server...
[20.11.2014 03:11:59]   Commencing Synchronization, please wait on the SQL Server to finish...

[20.11.2014 03:12:00]   Movies failed to be synchronized!, please see the following Error message...
Invalid column name '$ACTION'.

[20.11.2014 03:12:00]   Tag Lines are being processed, please wait...

[20.11.2014 03:12:04]   Data has been send to the server...
[20.11.2014 03:12:04]   Commencing Synchronization, please wait on the SQL Server to finish...

[20.11.2014 03:12:04]   Data has been send to the server...
[20.11.2014 03:12:04]   Commencing Synchronization, please wait on the SQL Server to finish...

[20.11.2014 03:12:05]   Tag Lines failed to be synchronized!, please see the following Error message...
Invalid column name '$ACTION'

.
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 
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.