Concert Calendar/reviews Database Development?

May 2, 2008

Hi,

I'm neck-deep in trying to normalize all the info I need into separate tables, but I seem to have hit a wall running.

I was curious as to what the "best" way is to develop a database of concert events would be? What I think I've figured so far would be if I created a table called events...that would be 1 row of data per concert event. Each row could then have a 'event_id' as PK, 'date', and a column with the associated 'band_id' from the bands table. Then anytime the date was accessed (assuming a populated row for that date), a list of concerts for that date would show.

I would also like to use the 'event_id' as an access point for my reviews table...where, quite obviously, I would like to be able to have reviews associated with each event from the calendar as well. Does all this seem right? Or is there a better way (i.e. more efficient, smaller database, and/or use less memory)? How, for example (in short, obviously), does a website like Pollstar.com database their events?

I guess my question with regards to this database is also...within my bands table, should I include their tour dates? Or should I put the band_id in my events table?

I was hoping to get a just a little bit of direction so I don't turn some baby missteps into a long-term project down the wrong road. Any help or response is greatly appreciated. Thanks again!

View 4 Replies


ADVERTISEMENT

HP Data Protector For Sql Server -- Reviews?

Sep 20, 2005

Our IT is pushing HP Data Protector (HPDP) on us. Anyone ever see it in action?

they are telling us NOT to use the standard MS SQL Backup/restore process, because their HPDP does it for us.

But I have hesitations.

Anyone?

`Le

View 7 Replies View Related

How To Go From A Database To A Calendar Format?

Jul 23, 2005

HelloMy department has a SQL server database that is used to all facets ofproduction within our department. This includes key production jobsteps, project names, numbers and descriptions.The calendar is currently done manually as an Excel document. The userrecieves hard copies of the required information, then keys it into theappropriate place on the Excel document.We would like to pull information out of that database, and put it in amonthly calendar format. For example, take a project name and the dateassociated with that project, and put it on a calendar in theappropriate date "square".If you have information or experience with software that can be used toaccomplish this task, I would appreciate hearing your advice.Thanks in advance.

View 1 Replies View Related

Connection Problem With Database And Calendar

Nov 18, 2006

hi folks:imports system.data  Private schedule As New DataView()    Protected Sub Page_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.PreRender        schedule = CType(srcSchedule.Select(DataSourceSelectArguments.Empty), DataView)        schedule.Sort = "entryDate"    End Sub///////////////////////whenever i run the above code an error message comes up with the following message:Object reference not set to an instance of an object.and it highlights the bold message mention in the code. I wanted this code to highlight the dates in the calendar that have events on them.Can you please help. thank you very much in advance.

View 1 Replies View Related

Calendar Control And Database Connection

Dec 11, 2005

Hi,I m trying to implement a calendar, where you can select certain dates and view list of events for that day. The list is generated from database. I found a script on the web that is quite similar to what i want to achieve. I tried to run this script, however I get an exeption saying:An error has occurred while establishing a connection to the server. .... error: 40 - Could not open a connection to SQL Server)This is the code:SqlConnection mycn;    SqlDataAdapter myda;    DataSet ds = new DataSet();    DataSet dsSelDate;    String strConn;    private void Page_Load(object sender, System.EventArgs e)    {        // Put user code to initialize the page here        strConn = "Data Source=localhost;Initial Catalog=pubs";                mycn = new SqlConnection(strConn);        myda = new SqlDataAdapter("Select * FROM EventsTable", mycn);        myda.Fill(ds, "Table"); //This where I get the exeption    }    protected void CalendarDRender(object sender, System.Web.UI.WebControls.DayRenderEventArgs e)    {        // If the month is CurrentMonth        if (!e.Day.IsOtherMonth)        {            foreach (DataRow dr in ds.Tables[0].Rows)            {                if ((dr["EventDate"].ToString() != DBNull.Value.ToString()))                {                    DateTime dtEvent = (DateTime)dr["EventDate"];                    if (dtEvent.Equals(e.Day.Date))                    {                        e.Cell.BackColor = System.Drawing.Color.PaleVioletRed;                    }                }            }        }        //If the month is not CurrentMonth then hide the Dates        else        {            e.Cell.Text = "";        }    }    private void Calendar1_SelectionChanged(object sender, System.EventArgs e)    {        myda = new SqlDataAdapter("Select * from EventsTable where EventDate='" +            Calendar1.SelectedDate.ToString() + "'", mycn);        dsSelDate = new DataSet();        myda.Fill(dsSelDate, "AllTables");        if (dsSelDate.Tables[0].Rows.Count == 0)        {            DataGrid1.Visible = false;        }        else        {            DataGrid1.Visible = true;            DataGrid1.DataSource = dsSelDate;            DataGrid1.DataBind();        }    }        
    Can some one tell me what is wrong with the code.Thank You
WATCH THIS SPACE

View 1 Replies View Related

How To Design A Database For A Booking Calendar

May 15, 2015

how to design a database for this king of booking?

View 5 Replies View Related

Updating A Production Database With Back Up Of Development Database

May 11, 2007

Can someone provide a step by step tutorial for this? I'd like to safely update a database that is used for a website without much or any downtime.

View 1 Replies View Related

Development Database, What To Use?

May 19, 2004

The web hotel I am using have MS SQL server installed. I do not have it on my local development PC.

How do I develop and test a website, locally, using MS SQL DB, without having MS SQL sever. Is there any light MS SQL sever I can use with a good user interface, and then just upload the DB to MS SQL server?

Please advise, NewBe2

View 1 Replies View Related

Database Development

Dec 20, 2007

Hi,

Can anyone let me know how to deal with the following things:

Is there any links for database coding, test data generation, editing,data cleansing, migration and loading with respect to Database Developing.

Thanks in Advance.

View 2 Replies View Related

DataBase Development Server

Aug 9, 2005

Hi,I am trying to create a development database server (make use of an old machine), with which to learn about sql 2005 and oracle etc.  I'm using VS 2005 Beta 2 on my development/workstation machine.My workstation and the prospective server are connected via a router and can 'see' each other.I have installed win 2003 server on two seperate partitions (multiple boot) and installed sql server 2005 on one partition and will install oracle 10g on the other. (I understand these two databases can run on the same machine/OS, but I just wanted to keep things tidy and I won't be using them at the same time, so ...).My question is how do I/should I configure win 2003 server / sql server 2005 on my server machine, in order to be able to connect from my workstation via vs 2005 beta 2 ?Any suggestions or resources on configuration appreciated.

View 2 Replies View Related

Tracking Changes To A SQL Server Database During Development

Apr 24, 2008

I am running both SQL Server 2000 and SQL Server 2005.

Lets say I have a live database that is version 1 for an application. The database is copied onto a development machine to develop version 2 of the application. I want to be able to take a snapshot of the database and then get a program to write all the changes made after the snapshot into sql code. This is so I can run this sql code on the live database and transform version 1 to version 2.

Is there any program/tool that will allow me to do this?

Jagdip

View 4 Replies View Related

Restore Production Database To Development

Jul 23, 2005

I have a production database with a backup job that creates files with thenaming convention dbname_db_200503291800.bak. I want to schedule a restorejob that will retire yesterdays backup. How can I write my restore statementso that it will specify the backup file with yesterdays date.Thanks

View 1 Replies View Related

Move Database From Development To Production

Nov 2, 2006

What's the best way to move database from development to production environment?

View 1 Replies View Related

Updating Structure Between Development And Public Database.

Feb 7, 2006

Hi.
I have a question that I have been thinking about for some time. Have in mind that I'm somewhat a SQL newbe.
I work on a few webapplications that are database driven applications. When we desides to change something in the database, we normaly do the changes on our replicat development database, and after some testing the changes are suppose to be implamented in the live, public database.
Now, what is the best way, or recomended way to do this? Today we bo it manualy. But at one time I experimented with the export/import wizard to se if it was possible. What I want to do is change de design of a tabel, without loosing the original data, and without geting the data from the development database into the live database.
To export an stored proccedure, I usualy just create a SQL-script for the procedurs in question and the runthe script against the public DB using the Query Analyser. But if I do the same procedure on a table, I loss all the data in the database.
Do I make any sense at all?
Any tips/idea/best practise on this subject?
/Johan Christensson

View 1 Replies View Related

Comparing Development, Test & Production Database

Aug 2, 2001

Hi,

We're using SQL Server 2000 as back end in our web project. The problem is we've 3 different copies of same database - one each for Development, Test and Production sitting in 2 different machines.

My question is - is there any tool for comparing the objects (tables, stored procedures, etc) ?

Thanks,
Harish

View 2 Replies View Related

Database Environment Naming Production -vs- Development

Jul 23, 2005

I have been looking for some documentation that would support or rejectmy opinion on Production -vs- Development naming conventions. Ibelieve that each environment should be housed on separate servers withidentical names, access, users, stored procs....... If you eitheragree or disagree with this methodology, I would appreciate your input.TIA,Bill

View 5 Replies View Related

Refreshing A Development Database With Production Data

Jan 17, 2007

Hello,

I am trying to refresh a test database with data from a production database. Both database structures are identical, e.g. constraints, stored procs, PK, etc. I am trying to create a package in SSIS that accomplishes this task and I am having extensive problems. The import export wizard is out of the question because the constaints are not carried over, plus when I try to refresh the data using the import export wizard, it fails on 1 specific table because of a column in that table named "Error code". I think "Error code" is a micrsoft keyword, so it fails on this column. Does anyone know a workaround that I can do to accomplish this simple task, that could be completed in minutes using DTS. I understand that SSIS is not as straight forward as DTS, but this task is something that DBA's do on a regular basis and therefore should not be this difficult.

Any help would be appreciated,

David

View 1 Replies View Related

Database Development/Deployment Best Practise For Large Teams

Jan 2, 2008

Hi,
I work with a large team developing ASP.NET application that has a large database with over 50 complex stored procedures.  It is proving more and more difficult and time consuming to centralise the development and update of the database changes and I was wondering if there were any best practises/tools that could be recommended.  I have looked on the web for good articles and haven't found anything difinitive (except that Team Foundation Server is the way forward)..
A brief background to the current process is that everyone develops on the same database, and then updates the stored procedure scripts in source safe (manually).  Then when we do a new release someone builds a script of all the database updates and runs it.  There are issues related to developers updating there stored procedures over other peoples and other concurrency.
I am looking to move all the developers to start using local databases so that there work only effects them, but then this brings up problems of keeping all the local databases up to date whenever they get the latest source code.  The only way I currently see is to build a database update program, that will run and update to the latest version.
Surely this must be a common issue?  Anyone have any good ideas/concepts?
Also our setup is Visual Studio 2005, SQL Server 2005 and Source Safe 2005. 
Cheers,
 Andrew Thomas

View 5 Replies View Related

Recovery :: How To Restore Database To Existing Development Server

Aug 19, 2015

We are using SQL Server 2012 for both production and development server. Currently, i have plan to transfer the full backup of SQL server database to the development server and then restore it on the development server for testing purpose, so we don't want to disturb on the production.

I have successfully backup the database from the production server and transfer to the development server. however, i encounter some difficulties when trying to do restore. my question is:

1. do i need to firstly create an empty database on the development server and then restore it into this empty database? say i create database call "Test2", then i perform a restore into this database.

2. currently, there is already an existing database being restored previously in the development server and this database is actually the older version of the backup that being restored by the previous engineer. should i remove this database first and restore a new one or both of the database can coexist as long as we put different name for the database?

View 6 Replies View Related

Move Sql Database From Development Machine To Server With Active Directory

Dec 23, 2004

Hi all! I know I might sound stupid, but I have this problem. I have developed my database on my laptop which does not use Active directory. Lets say I access the database with: SPIDERMANDB1 on SQL server, where the name of my laptop is SPIDERMAN, and the database is DB1. Now, I create an SQL script from sql server and make the necessary changes, like changing the computer name to say, SUPERMAN where my deployment server's name is SUPERMAN. But when I run the SQL script on the SUPERMAN server, it gives me an error like: "User or role SUPERMANDB1 does not exist in this database". I have deployed databases in this way on servers without Acive directory, so I'm sure its not a mistake on my side. So how am I supposed to go around this active directory thingi! Please help me out! I'm counting on u guys!

Wes

View 4 Replies View Related

How Do I Copy The Index Statistics To A Development Database Server Without Data.

Jul 16, 2007



I want to be able to reproduce my production execution plans on development with copying data.

View 1 Replies View Related

How To Deploy Updated Database From Development Environment To Live Environment?

Nov 16, 2005

I have finished a change request from our client. I need to update clients' database with the one in developments.Here is the changes i made to database:Added/Changed some tablesAdded/Changed some stored proceduresAdded data to some dictionary tableThe data in clients' current database MUST be kept. So how can I merge the changed information to clients' database?

View 3 Replies View Related

Development Server Database Refresh From Production Server

Nov 9, 2006

Hi
Can we use BCP AND/OR BULK INSERT to do development server databse refresh from production server . I have to do this by following the rules below:

- no truncation of source table
- update of changed or new records only.


I know we can use replication, dts and other methods for this but I need information about this one.

Thanks

View 1 Replies View Related

Store A Calendar

Nov 8, 2004

Hi,

I'm developing a site in asp.net and one of the main parts is to manage a timesheet.
Now the problem i'm facing is; how do I save this timesheet in a database in a way that it's easy to save and easy to query from.
I'm thinking about problems as i.e. 1st of a month is middle of the week, so I can't save it like this:

Month Week Mon Tue Wed Thu Fri Sat Sun
1 5 .. .. .. .. .. .. ..
2 1 .. .. .. .. .. .. ..

Anyway, I got stuck to find the best method, maybe someone has made something like this?

Thanks in advance!

Pieje

View 2 Replies View Related

Outlook Calendar

Nov 27, 2007





When I try to view someone else's Calendar in Outlook I get this message:

The messaging interface has returned an unknown error. If the problem persists, restart Outlook.

Of course restarting Outlook resolves nothing. Please help.

View 1 Replies View Related

Report To Look Like A Calendar

Sep 17, 2007



I have thought about this, and I cannot in my head come up with a way to create this. Maybe I am thinking about it too much, or maybe it is this difficult and I will need a 3rd party tool.

My users have requested a SQL Reporting Services report that looks like a calendar. Each page will be one month on the calendar. And then the data will fall on the calendar according to a date field in the database. It should not be all that difficult, but I cannot think of a way to acheive this.

Has anyone tried to build a report that is basically just a calendar, and each page is a month of the calendar? If so, did you build it using the standard SQL reporting services tools, or did you purchase a 3rd party vendor?

Let me know what route I should look to follow.

Thank you!

T.J.

View 5 Replies View Related

ASP.NET C# Calendar DataAccess Issue

Oct 10, 2007

Hello there
I'm having a little issue with Updating a SQL Table. *Deep Breath* OK, lets begin from the start...
I Have a Table Called Job. I've an ASP Page setup to insert a new record into the Job table via a DetailsView Control with an SQLDataSource bound to it. This table has many columns in it, 4 of which are DateTime columns. I use a calendar Control from the toolbox for the DateTime selection and bound all the  Calender control's SelectedDate to: SelectedDate='<%# Bind('EnteredDate') %>' using the EnteredDate field as my example.
 I only insert DateTime Values into 2 of the 4 DateTime columns in the original INSERT, so the remaining 2 columns are NULL. I have an UPDATE setup on a different page to edit the previously inserted rows in job using another SQLDataSource again using the bind method for calendars: '<%# Bind('RevisedDate') %>'
 My Problem is (according to this post I found online http://www.thescripts.com/forum/thread529052.html ) the page crashes with "Specified cast is not valid". The reason being I'm trying to bind to the remaining 2 NULL DateTime columns in an attempt to update them with a value my user will not be able to insert in the original INSERT. The solution Code I found on the link above is in VisualBasic and I have had little luck in trying to convert it into C# to even see if it solves my problem:
VB Code:
Function FixDBNull(ByVal inVal As Object) As DateTime    If inVal Is DBNull.Value Then         Return DateTime.Now    Else         Return inVal    End IfEnd Function
ASP Code:
<asp:calendar id="calEditRevisedDate" runat="server"selecteddaystyle-backcolor="red"selecteddate='<%#FixDBNull(eval("RevisedDate")) %>'visibledate='<%# FixDBNull( eval("RevisedDate")) %>'selectorstyle-backcolor="Green"></asp:calendar>
Any suggestions or work arounds would be greatly appreciated
Thank You

View 4 Replies View Related

Calendar Filtering In Gridview

Feb 3, 2008

  
I have 2 dropdownlist and a gridview.  The dropdownlists filter the
gridview, but now I have added two calendars and two textboxes.  After
user makes selections from the calendar the text boxes are populated
with the dates.  How do I add this to the following select parameter so
that the filtering/querying works properly? (what I have here does not
work in terms for the dates, but dropdownlists filter when I remove the
dates section):<asp:SqlDataSource ID="DATA" runat="server" ConnectionString="<%$ ConnectionStrings:DATA_Connection %>" 
         SelectCommand="SELECT * FROM [atable] WHERE(afield=@param1 or
@Param1='Select something' or((CONVERT(char(10), adate,
101)>=@param3 AND CONVERT(char(10), bdate, 101)<=@param4)) AND(bfield=@Param2 OR @Param2='Select something' or((CONVERT(char(10),
adate, 101)>=@param3 AND CONVERT(char(10), bdate, 101)<=@param4))"             UpdateCommand="Update atable set afield=@afield, bfield=@bfield where id=@ID" >                             <selectParameters>     <asp:controlparameter name="param1" controlid="DropDownList1" PropertyName="SelectedValue" type="String" />     <asp:controlparameter name="param2" controlid="DropDownList2" PropertyName="SelectedValue" type="String" />     <asp:ControlParameter Name="param3" ControlID="Textbox1" PropertyName="Text" Type="string" />     <asp:ControlParameter Name="param4" ControlID="Textbox2" PropertyName="Text" Type="string" />     </selectParameters>

View 3 Replies View Related

Connecting Mdb File To A Calendar

Feb 21, 2008

Hi Everyone.
 I’m trying to read data from a databasefile called database.mdf which has a connection string called “ConnectionString1â€?. The aim is to highlit specific days in my calender. For example if there is an event in my database that day on the calander will be highlited. The database has  a columb called “Dateâ€? in a table called “Datesâ€?. Please can you help? My knowlade in asp.net and VB is very limited. This is as far as I have gone. (I don’t realy understand the VB part as I have copyed it from somone) I just need the vb code to connect to the database.
 
Imports System.Data.SqlClientImports System.DataImports System.Data.OleDb
Partial Class _Default    Inherits System.Web.UI.Page    Protected Sub Calendar1_DayRender(ByVal sender As Object, ByVal e As DayRenderEventArgs)        If IsExistMeeting(e.Day.Date.ToString("MM/dd/yyyy")) Then            e.Cell.BackColor = System.Drawing.Color.Red            e.Cell.ForeColor = System.Drawing.Color.Yellow        End If
    End Sub
    Function IsExistMeeting(ByVal datestring As String) As Boolean        Dim constr As String = System.Configuration.ConfigurationManager.ConnectionStrings("ConnectionString1").ConnectionString.ToString() '"your connection string"        Dim connection As SqlConnection = New SqlConnection(constr)        Dim sqlsel As String = "select count(*) from Dates where CONVERT(char, date, 101)='" + datestring + "'"        Dim sda As SqlDataAdapter = New SqlDataAdapter(sqlsel, connection)        Dim ds As DataSet = New DataSet()        sda.Fill(ds, "Dates")        If ds.Tables("Dates").Rows.Count = 0 Then            Return False        End If        Return True    End FunctionEnd Class

View 2 Replies View Related

Using A Calendar Control In An SQL Report

May 15, 2008

We have developed several reports using VS 2005 and deployed them to our SQL 2005 reporting server. As most of our reports use date parameters we would like to incorporate a calendar control to allow users to select their date range as opposed to typing them in. I have done some reseach online but can only find vague references on how to do this. Has anyone out there been able to successfully deploy a calendar control onto an SQL report? Thanks!

View 2 Replies View Related

360-Day Calendar Year Function...

Jun 23, 2008

I'm looking for a function that will return an INTEGER that computes the number of days between two dates based on a 360-calendar year instead of using just the datediff function which is actual days.

If anybody knows where I could find something like this, I would be greatly appreciated.

Does this site have a library of user-defined sql functions? Or, does somebody have a site that you know of where there are a bunch?

Thanks,

South Side Rob

View 14 Replies View Related

Generating New Month In Calendar

Jan 21, 2014

i have inherited a sql database to work on and cannot seen to fix this error. its an availability calendar and at the end of each month a new month is generated, it by default makes all dates unavailable but i need them available. is this done in the database as a default??if a member has logged in recently then the avails populate fine but if they have not logged in for a while then they all show unavailable? i

View 3 Replies View Related

Job To Be Run Ever First For The Previous Calendar Month

Jan 18, 2007

Hi!I have a query that has to return bunch of data based on the calendarmonth. I have to make sure that it will return data to me for 28 daysif it is February and for 31 if it is August(for example). I need tobe able to execute it every first of every month for the past 30, 31 or28 days based on the calendar month. Is there a function or a storedprocedure that I can use to do that?Thank you,T.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved