|
|
|
Paw,
This is almost exactly the resource I am looking for! I can only program tSQL and really need what you have here PLUS the distributors.list table. Would it be possible for you to add the distributors table to your utility? Also, please let me know if this might work in MSSQL 2014. I can install 2008 if necessary, but 2014 would be great. Thank you for your response.
Jim
|
|
|
|
|
|
Thanks Paw. That's encouraging. I now have SQL 2014. However, in Visual Studio 2013 the .csproj files show 'incompatable' when I try to open MyMDb.sln, and in VS 2012 it says 'unavailable'. I am thinking that I'm using the wrong version of VS or perhaps I am missing something in my installation. Any thoughts to get me started?
Jim
|
|
|
|
|
I am trying to sync. I tried all the things that is written. But I get this all the time cos of stored procedure.
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'
.
|
|
|
|
|
What version of SQL are you running ? and did you change any code at all ?
With great code, comes great complexity, so keep it simple stupid...
|
|
|
|
|
How can I get the complete imdb database, including grades?
|
|
|
|
|
This is a nice tool. Thanks for posting. However, some of the database SQL references did not start with [dbo] but with [imdb] and returned errors or exceptions. This was both in code and stored procedures. Any suggestions?
James Huebsch
|
|
|
|
|
The IMDB schema is primarily for use in the import fase, thats why its in a different schema.
If you have a datareader user, that user should only be allowed to look into the dbo schema.
You say there are errors and exceptions, can you please post them ???
With great code, comes great complexity, so keep it simple stupid...
|
|
|
|
|
The first three tabs appear to work without errors. The Synchonize tab gives the following errors.
[7/24/2013 10:00:57 PM] Prepare SQL Server for Operations...
[7/24/2013 10:00:57 PM] Change script command to MyMDb database... Success!
[7/24/2013 10:00:57 PM] Preparing the bulk tables... Success!
[7/24/2013 10:00:57 PM] Movies are being processed, please wait...
[7/24/2013 10:00:57 PM] Movies failed to be synchronized!, please see the following Error message...
Cannot access destination table '[imdb].[MediaEntry]'.
[7/24/2013 10:00:57 PM] Tag Lines are being processed, please wait...
[7/24/2013 10:00:57 PM] Tag Lines failed to be synchronized!, please see the following Error message...
Cannot access destination table '[imdb].[TagLine]'.
[7/24/2013 10:00:57 PM] Plots are being processed, please wait...
[7/24/2013 10:00:57 PM] Plots failed to be synchronized!, please see the following Error message...
Cannot access destination table '[imdb].[Plot]'.
[7/24/2013 10:00:57 PM] Genres are being processed, please wait...
[7/24/2013 10:00:58 PM] Genres failed to be synchronized!, please see the following Error message...
Invalid object name 'dbo.Genre'.
[7/24/2013 10:00:58 PM] Countries are being processed, please wait...
[7/24/2013 10:00:58 PM] Countries failed to be synchronized!, please see the following Error message...
Invalid object name 'dbo.ISO3166'.
[7/24/2013 10:00:58 PM] Cleaning SQL Server after Operations...
[7/24/2013 10:00:58 PM] Change script command to MyMDb database... Success!
[7/24/2013 10:00:58 PM] Clean up the bulk tables... Success!
[7/24/2013 10:00:58 PM] Shrinking Data file... Success!
[7/24/2013 10:00:58 PM] Shrinking Log file... Success!
James Huebsch
|
|
|
|
|
|
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
|
|
|
|
|
Ok, then try restart the application, without Re-Building the Database, and then run the download operation, and after that, once again restart and run the sync operation. and let me know if that Works !
With great code, comes great complexity, so keep it simple stupid...
modified 25-Jul-13 14:08pm.
|
|
|
|
|
This procedure appears to work. Below is the messages from the sync operation after skipping the rebuild and executing the download / restart / sync.
[7/25/2013 1:33:00 PM] Prepare SQL Server for Operations...
[7/25/2013 1:33:00 PM] Change script command to MyMDb database... Success!
[7/25/2013 1:33:00 PM] Preparing the bulk tables... Success!
[7/25/2013 1:33:02 PM] Movies are being processed, please wait...
[7/25/2013 1:34:12 PM] Data has been send to the server...
[7/25/2013 1:34:12 PM] Commencing Synchronization, please wait on the SQL Server to finish...
[7/25/2013 1:37:08 PM] 2583953 Movies handled, 2583953 New, 0 Updated and 0 Deleted
[7/25/2013 1:37:08 PM] Movies where successfully synchronized
[7/25/2013 1:37:08 PM] Tag Lines are being processed, please wait...
[7/25/2013 1:37:09 PM] Data has been send to the server...
[7/25/2013 1:37:09 PM] Commencing Synchronization, please wait on the SQL Server to finish...
[7/25/2013 1:37:09 PM] Data has been send to the server...
[7/25/2013 1:37:09 PM] Commencing Synchronization, please wait on the SQL Server to finish...
[7/25/2013 1:37:14 PM] 142399 Tag Lines handled, 142399 New, 0 Updated and 0 Deleted
[7/25/2013 1:37:14 PM] Tag Lines where successfully synchronized
[7/25/2013 1:37:14 PM] Plots are being processed, please wait...
[7/25/2013 1:37:41 PM] Data has been send to the server...
[7/25/2013 1:37:41 PM] Commencing Synchronization, please wait on the SQL Server to finish...
[7/25/2013 1:37:57 PM] 338119 Plots handled, 338119 New, 0 Updated and 0 Deleted
[7/25/2013 1:37:57 PM] Plots where successfully synchronized
[7/25/2013 1:37:57 PM] Genres are being processed, please wait...
[7/25/2013 1:38:11 PM] Data has been send to the server...
[7/25/2013 1:38:11 PM] Commencing Synchronization, please wait on the SQL Server to finish...
[7/25/2013 1:38:37 PM] 1569791 Genres handled, 1569791 New, 0 Updated and 0 Deleted
[7/25/2013 1:38:37 PM] Genres where successfully synchronized
[7/25/2013 1:38:37 PM] Countries are being processed, please wait...
[7/25/2013 1:38:52 PM] Data has been send to the server...
[7/25/2013 1:38:52 PM] Commencing Synchronization, please wait on the SQL Server to finish...
[7/25/2013 1:39:12 PM] 1342945 Countries handled, 1342945 New, 0 Updated and 0 Deleted
[7/25/2013 1:39:12 PM] Countries where successfully synchronized
[7/25/2013 1:39:12 PM] Cleaning SQL Server after Operations...
[7/25/2013 1:39:12 PM] Change script command to MyMDb database... Success!
[7/25/2013 1:39:12 PM] Clean up the bulk tables... Success!
[7/25/2013 1:39:12 PM] Shrinking Data file... Success!
[7/25/2013 1:39:14 PM] Shrinking Log file... Success!
James Huebsch
|
|
|
|
|
|
one more thing, can you please verify that the imdb schema is owned by dbo !
With great code, comes great complexity, so keep it simple stupid...
|
|
|
|
|
Well, I'm not a DB expert so I'm not sure what you mean by the imdb schema is "owned" by dbo.
James Huebsch
|
|
|
|
|
|
The program crashes when its trying to create a DB at line number 903 in Form1.cs. What could be the issue?
|
|
|
|
|
Fixed it by putting the <pre lang="c#">rtn = !rs.IsDBNull(0);</pre> into a try block with the catch block setting rtn to false.
|
|
|
|
|
|
Minor typos: "where" should be "were" (in the progress screen[s]).
|
|
|
|
|
|
Its simply unbelievable....
|
|
|
|
|