Any sample banking database to download?

I am a .net developer, know how to get my data from the database
through SQL. I am getting interested in database design, and am
wondering if there are any sample banking database to download.
Basically, for practice, I would like to design a credit card
company's database, such that users can check their charge history,
payment history, current balance, current balance due, etc., pretty
much functionalities which most credit card services provide online.
Any suggestion about how to get started?
Thank you very much."gnewsgroup" wrote:
> I am a .net developer, know how to get my data from the database
> through SQL. I am getting interested in database design, and am
> wondering if there are any sample banking database to download.
> Basically, for practice, I would like to design a credit card
> company's database, such that users can check their charge history,
> payment history, current balance, current balance due, etc., pretty
> much functionalities which most credit card services provide online.
> Any suggestion about how to get started?
> Thank you very much.
>
Hi
Although not a complete schema
http://www.microsoft.com/sql/editions/express/starterschemas.mspx may give
you parts such as customer management etc. The transaction history is a very
similar situation to a invoice item/detail where each item is a card
transaction.
John|||On Apr 28, 8:10 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> "gnewsgroup" wrote:
> > I am a .net developer, know how to get my data from the database
> > through SQL. I am getting interested in database design, and am
> > wondering if there are any sample banking database to download.
> > Basically, for practice, I would like to design a credit card
> > company's database, such that users can check their charge history,
> > payment history, current balance, current balance due, etc., pretty
> > much functionalities which most credit card services provide online.
> > Any suggestion about how to get started?
> > Thank you very much.
> Hi
> Although not a complete schemahttp://www.microsoft.com/sql/editions/express/starterschemas.mspxmay give
> you parts such as customer management etc. The transaction history is a very
> similar situation to a invoice item/detail where each item is a card
> transaction.
> John
Very cool. Thank you very much. I will closely study a few of them
and may get an idea.|||On Apr 28, 8:10 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> "gnewsgroup" wrote:
> > I am a .net developer, know how to get my data from the database
> > through SQL. I am getting interested in database design, and am
> > wondering if there are any sample banking database to download.
> > Basically, for practice, I would like to design a credit card
> > company's database, such that users can check their charge history,
> > payment history, current balance, current balance due, etc., pretty
> > much functionalities which most credit card services provide online.
> > Any suggestion about how to get started?
> > Thank you very much.
> Hi
> Although not a complete schemahttp://www.microsoft.com/sql/editions/express/starterschemas.mspxmay give
> you parts such as customer management etc. The transaction history is a very
> similar situation to a invoice item/detail where each item is a card
> transaction.
> John
Thank you. I downloaded those databases, unzipped. But because they
don't come with the log file (*.ldf), I cannot attach them, and
therefore, cannot use it.
I googled, and found this:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=85187
I followed the method provided over there by BashTheGeek, but could
not succeed. I am using SQL Server 2005 Express and got an error
which says something like I cannot ad hoc change the status of a
database.
I don't know why M$ could not have included the LDF file and make our
newbies' life easier. It's called starter database, right?
Any hint is highly appreciated.|||On Apr 29, 9:53 am, gnewsgroup <gnewsgr...@.gmail.com> wrote:
> On Apr 28, 8:10 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
>
> > "gnewsgroup" wrote:
> > > I am a .net developer, know how to get my data from the database
> > > through SQL. I am getting interested in database design, and am
> > > wondering if there are any sample banking database to download.
> > > Basically, for practice, I would like to design a credit card
> > > company's database, such that users can check their charge history,
> > > payment history, current balance, current balance due, etc., pretty
> > > much functionalities which most credit card services provide online.
> > > Any suggestion about how to get started?
> > > Thank you very much.
> > Hi
> > Although not a complete schemahttp://www.microsoft.com/sql/editions/express/starterschemas.mspxmaygive
> > you parts such as customer management etc. The transaction history is a very
> > similar situation to a invoice item/detail where each item is a card
> > transaction.
> > John
> Thank you. I downloaded those databases, unzipped. But because they
> don't come with the log file (*.ldf), I cannot attach them, and
> therefore, cannot use it.
> I googled, and found this:
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=85187
> I followed the method provided over there by BashTheGeek, but could
> not succeed. I am using SQL Server 2005 Express and got an error
> which says something like I cannot ad hoc change the status of a
> database.
> I don't know why M$ could not have included the LDF file and make our
> newbies' life easier. It's called starter database, right?
> Any hint is highly appreciated.
Never mind, at an MSDN forum, one guy says that we when attach the
database, simply remove the log file in the dialog box, and attach
it. When it is attached the database will create a log file. That
was easy.|||On Apr 29, 9:53 am, gnewsgroup <gnewsgr...@.gmail.com> wrote:
> On Apr 28, 8:10 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
>
> > "gnewsgroup" wrote:
> > > I am a .net developer, know how to get my data from the database
> > > through SQL. I am getting interested in database design, and am
> > > wondering if there are any sample banking database to download.
> > > Basically, for practice, I would like to design a credit card
> > > company's database, such that users can check their charge history,
> > > payment history, current balance, current balance due, etc., pretty
> > > much functionalities which most credit card services provide online.
> > > Any suggestion about how to get started?
> > > Thank you very much.
> > Hi
> > Although not a complete schemahttp://www.microsoft.com/sql/editions/express/starterschemas.mspxmaygive
> > you parts such as customer management etc. The transaction history is a very
> > similar situation to a invoice item/detail where each item is a card
> > transaction.
> > John
> Thank you. I downloaded those databases, unzipped. But because they
> don't come with the log file (*.ldf), I cannot attach them, and
> therefore, cannot use it.
> I googled, and found this:
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=85187
> I followed the method provided over there by BashTheGeek, but could
> not succeed. I am using SQL Server 2005 Express and got an error
> which says something like I cannot ad hoc change the status of a
> database.
> I don't know why M$ could not have included the LDF file and make our
> newbies' life easier. It's called starter database, right?
> Any hint is highly appreciated.
Never mind, I found at an MSDN forum where one guy says that when we
try to attach the mdf database file, simply remove the log file from
the dialog box and when it is attached, the database will create a log
file for it. That was easy.|||> I followed the method provided over there by BashTheGeek, but could
> not succeed. I am using SQL Server 2005 Express and got an error
> which says something like I cannot ad hoc change the status of a
> database.
The poster should have been more clear about the scenario in which to use
the sp_configure "allow updates" syntax. This option is not needed at all
when the database has been detached or otherwise cleanly shut down. In fact,
the ability to modify the system catalog, which is what that syntax allows,
is not even allowed in SQL Server 2005, That's why you're getting the error
that you are.
Use either sp_attach_single_file (see
http://msdn2.microsoft.com/en-us/library/ms174385.aspx for an example)
or the following syntax introduced in SQL Server 2005:
CREATE DATABASE <db_name>
ON (FILENAME = '<dir path><file_name.mdf'>')
FOR ATTACH
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
"gnewsgroup" <gnewsgroup@.gmail.com> wrote in message
news:c761f2e5-ec29-425a-8a39-7c6395e4d79d@.b64g2000hsa.googlegroups.com...
> On Apr 28, 8:10 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
>> "gnewsgroup" wrote:
>> > I am a .net developer, know how to get my data from the database
>> > through SQL. I am getting interested in database design, and am
>> > wondering if there are any sample banking database to download.
>> > Basically, for practice, I would like to design a credit card
>> > company's database, such that users can check their charge history,
>> > payment history, current balance, current balance due, etc., pretty
>> > much functionalities which most credit card services provide online.
>> > Any suggestion about how to get started?
>> > Thank you very much.
>> Hi
>> Although not a complete
>> schemahttp://www.microsoft.com/sql/editions/express/starterschemas.mspxmay
>> give
>> you parts such as customer management etc. The transaction history is a
>> very
>> similar situation to a invoice item/detail where each item is a card
>> transaction.
>> John
> Thank you. I downloaded those databases, unzipped. But because they
> don't come with the log file (*.ldf), I cannot attach them, and
> therefore, cannot use it.
> I googled, and found this:
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=85187
> I followed the method provided over there by BashTheGeek, but could
> not succeed. I am using SQL Server 2005 Express and got an error
> which says something like I cannot ad hoc change the status of a
> database.
> I don't know why M$ could not have included the LDF file and make our
> newbies' life easier. It's called starter database, right?
> Any hint is highly appreciated.|||On Apr 29, 1:01 pm, "Gail Erickson [MS]" <ga...@.online.microsoft.com>
wrote:
> > I followed the method provided over there by BashTheGeek, but could
> > not succeed. I am using SQL Server 2005 Express and got an error
> > which says something like I cannot ad hoc change the status of a
> > database.
> The poster should have been more clear about the scenario in which to use
> the sp_configure "allow updates" syntax. This option is not needed at all
> when the database has been detached or otherwise cleanly shut down. In fact,
> the ability to modify the system catalog, which is what that syntax allows,
> is not even allowed in SQL Server 2005, That's why you're getting the error
> that you are.
> Use either sp_attach_single_file (seehttp://msdn2.microsoft.com/en-us/library/ms174385.aspxfor an example)
> or the following syntax introduced in SQL Server 2005:
> CREATE DATABASE <db_name>
> ON (FILENAME = '<dir path><file_name.mdf'>')
> FOR ATTACH
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online fromhttp://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
>
OK, that's great. But in the MSDN forum, 2 people were saying how
helpful the answer provided by BashTheGeek was. So that sorta misled
me. :)
So,
CREATE DATABASE <db_name>
ON (FILENAME = '<dir path><file_name.mdf'>')
FOR ATTACH
will take care of the whole thing even without an LDF file?
Let me try it out. But, simply try attaching it after removing the ldf
file is easy, too.|||OK, that's great. But in the MSDN forum, 2 people were saying how
helpful the answer provided by BashTheGeek was. So that sorta misled
me. :)
Yes, you were mislead because the context of their particular scenario (i.e.
the database they were trying to attach had not been cleanly shut down) was
not made clear in the post.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
"gnewsgroup" <gnewsgroup@.gmail.com> wrote in message
news:8ee8eec9-4061-43b5-a237-79cfe0ae217e@.34g2000hsh.googlegroups.com...
> On Apr 29, 1:01 pm, "Gail Erickson [MS]" <ga...@.online.microsoft.com>
> wrote:
>> > I followed the method provided over there by BashTheGeek, but could
>> > not succeed. I am using SQL Server 2005 Express and got an error
>> > which says something like I cannot ad hoc change the status of a
>> > database.
>> The poster should have been more clear about the scenario in which to use
>> the sp_configure "allow updates" syntax. This option is not needed at all
>> when the database has been detached or otherwise cleanly shut down. In
>> fact,
>> the ability to modify the system catalog, which is what that syntax
>> allows,
>> is not even allowed in SQL Server 2005, That's why you're getting the
>> error
>> that you are.
>> Use either sp_attach_single_file
>> (seehttp://msdn2.microsoft.com/en-us/library/ms174385.aspxfor an example)
>> or the following syntax introduced in SQL Server 2005:
>> CREATE DATABASE <db_name>
>> ON (FILENAME = '<dir path><file_name.mdf'>')
>> FOR ATTACH
>> --
>> Gail Erickson [MS]
>> SQL Server Documentation Team
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights
>> Download the latest version of Books Online
>> fromhttp://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
> OK, that's great. But in the MSDN forum, 2 people were saying how
> helpful the answer provided by BashTheGeek was. So that sorta misled
> me. :)
> So,
> CREATE DATABASE <db_name>
> ON (FILENAME = '<dir path><file_name.mdf'>')
> FOR ATTACH
> will take care of the whole thing even without an LDF file?
> Let me try it out. But, simply try attaching it after removing the ldf
> file is easy, too.
>

Any one knows the location of the SqlServersamples.msi? plz let me konw

Hi i am going through with the videos on reporting server. in the videos they have given files to download from the particular URL. but now they have changed and i cannot find these files on reporting server installations. plz any one know where the location of these files exists.

i need to download four files from the following link

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

but i can find only two from this link they are:

Install Microsoft SQL Server 2005 Express Edition with Advanced Services

Microsoft SQL Server 2005 Express Edition Toolkit

but i dont find remaining two links which says in this video

i cant find SQLserverSample.MSI. any one know the location of this file plz.

plz click for the video link herehttp://www.asp.net/learn/sql-videos/video-112.aspx

SQL Server code samples and sample databases are now hosted on CodePlex

for more information:

https://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

for download:

http://codeplex.com/SqlServerSamples

for the msi files:

http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004

thanks

|||

Try this for the msi:

http://www.codeplex.com/MSFTISProdSamples/Release/ProjectReleases.aspx?ReleaseId=4039

any installation no-no's?

We are installing MS Win Server 2003 and my old version (7?) of MSDE is not
supported. So I will download MSDE 2000 and install it. I do not have a lot
of experience installing MSDE. I installed it a few times years ago and, with
a few exceptions, it has run just fine since then.
I vaguely remember that I used all the installation defaults with MSDE. That
led to a problem whenever the administrator, or whoever the user was when it
was installed, changed thier password, the connection to the database no
longer worked.
Can anyone suggest a source of information that might be useful to me to
read before I install MSDE 2000?
Thanks for your help, John Brown
John Brown
hi John,
John Brown wrote:
> We are installing MS Win Server 2003 and my old version (7?) of MSDE
> is not supported. So I will download MSDE 2000 and install it. I do
> not have a lot of experience installing MSDE. I installed it a few
> times years ago and, with a few exceptions, it has run just fine
> since then.
> I vaguely remember that I used all the installation defaults with
> MSDE. That led to a problem whenever the administrator, or whoever
> the user was when it was installed, changed thier password, the
> connection to the database no longer worked.
> Can anyone suggest a source of information that might be useful to me
> to read before I install MSDE 2000?
> Thanks for your help, John Brown
modifying the "sa" password was a problem for MSDE 1.0 relating to Windows
account running the SQL Server Agent, but this does not apply to MSDE
2000... and there are not other problems I'm aware of.. but, of course, you
should have a look at the readme file bundled with the installation
package...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Any free examples that can download and view the database?

The free one that i have downloaded doesn't seem to be able to view the database. Is there any free database which i can download? Please advise. Thanks.

For example you can download sample databases here .

Answer Re: SQL Server 2000 DTS Tools Web Download

Is the Web Download to install SQL Server 2000 DTS tools available yet? If so where?

Thanks

DarrenIf I answer my own question, at least I'll get one right.

SQL 2000 DTS tools are now available as part of the -

Download details: Feature Pack for SQL Server 2005 Nov 2005
(http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en)

The direct link to the MSI-

http://www.microsoft.com/downloads/info.aspx?na=46&p=16&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&u=http%3a%2f%2fdownload.microsoft.com%2fdownload%2f4%2f4%2fd%2f44dbde61-b385-4fc2-a67d-48053b8f9fad%2fSQLServer2005_DTS.msi&oRef=http%3a%2f%2fforums.microsoft.com%2fMSDN%2fShowPost.aspx%3fPostID%3d126513%26SiteID%3d1|||

I have downloaded the dts tools and when I try to edit a dts package on a SQL2000 instance using the new SQL Server Management Studio, I still get the following errors:

Package Error
Error Source : Microsoft Data Transformation Services (DTS) Package
Errir Description : The DTS host failed to load or save the package properly.
<hit ok>
DTS Designer Error
The selected package cannot be opened. The DTS Designer has been closed.
<hit ok>
SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)
<hit ok>
it takes me to the dts designer (it doesn't close it like it says) and all of the icons in the workspace look like a default windows form icon. I can click on each of them to get the properties, transformations, etc. But I dare not save them.

Any idea how to fix this? Or am I not supposed to be able to manage SQL 2000 instances with this tool.

|||I'm experiencing the very same problem. It occurs even if you right-click on Data Transformation Services and select Open package file..., so it's not a server instance issue. Perhaps it requires the latest MDAC and/or SQL Server Native Client to be installed on the accessed server? Feels a bit buggy to me.|||The designer download does require MDAC 2.6 sp2 or newer, but you're likely to have that already.

-Doug
|||Can we install the SQL Native Client on a SQL2000 box? would that make any difference to the Management Studio?
|||You can install SNAC on SQL 2000 machines, after all that is what happens in side by side installations of SQL 2000 and SQL2005, but it is not requrired for DTS.

I can happily edit most 2000 packages (through the web download designer) on a clean SQL 2005 machine, pointing at an existing SQL 2000 instance. Sometimes I get invalid class string errors, since the SQL 2005 machine lacks some custom tasks I used with DTS. I do sometimes get a similar error to you, but haven't got around to seeing which components are used in a good package and a problem package. I suspect there may be a problem task. AS processing tasks gave some problems, but I skipped around it and haven't had time to work it yet.|||

After uninstalling the entire CTP (including the beta .NET framework) and reinstalling SQL 2005 enterprise I also downloaded and installed the S2k DTS designer web pack.

Now I can't create or save DTS packages in SQL 2000 without getting the same error. In SQL 2005 using the legacy designer I get mixed results.
So I created a new and very simple DTS package on a different (and clean) SQL 2000 machine that has never had SQL 2005 components installed. It worked fine on the SQL 2000 machine. But when I try to open it using the SQL 2005 designer that I downloaded I get the same annoying error. HOWEVER, certain older packages from that same clean SQL 2000 server CAN be edited and saved using the SQL 2005 designer.

This is WAY buggy. Am I missing a download? What about the backwards-compatible pack I saw with all of the (daunting) SQL 2005 downloads? Is there a sequence to doing this? Do I need to fully uninstall all SQL 2000 components first? Can I then reinstall them?

|||

I'm having the same problem. I never had SQL Server 2000 installed, I installed SQL Server 2005 & Visual Studio 2005, then the SQL Server 2000 DTS Designer Component package, but still get error message to install component when trying to open SQL Server 2000 DTS package.

I unintalled SQL Server 2005, then installed SQL Server 2000, ran Enterprise Manager ok, then installed SQL Server 2005, and then SQL 2000 Enterprise Manager will not run now, then installed DTS Component package, and still get same error message to install component when trying to open SQL Server 2000 DTS package.

Tom E.

|||

I get exactly the same errors and here's what I found... After trying to migrate a DTS package that failed to open I got a somewhat more informative error message out of the report. It stated that the package name cannot contain any of the following characters: / \ : [ ] . =.

It so happens many of my packages have ':', '.' in the names and so apparently they have changed this aspect as well (thanks Bill for the lack of documentation). Anyhow, after renaming the packages I was able to open them (still with errors but it worked) and migrate them. What a pain in the a**!!!

Hope this helps...

|||

I was also having same problem

error message was

SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)

The resolution

First download and install SQLServer2005_BC component for backward compatibility from microsoft

Then Install SQLServer2005_DTS component.

http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en)

It should work.In my case it was successfully leting me edit DTS package developed in SQL Server 2000 version

Thankx

|||

So what is the correct anwer here. It looks like it works for some but not for others. I happen to be one of the others that this does not work for. I've been working with a new box, clean install of the latest and greatest. ( a number of times, by the way. )

Sorry, but this is driving me nuts. Microsoft Support where are you?

|||

Scott,

There is no documented resolution from Microsoft that these forums will be frequented by MS staff.

You should seek support via your MSDN subscription and then PSS as far as I know.

-Jamie

|||

In case somebody else still experience the same problems...

I found help at:

http://support.microsoft.com/kb/917406/en-us

-duke63

|||

Sometimes happen the same and even only appears the arrows. I had a lot of problems with this messing up my Sql2k Entreprise Manager.