Large sample database - Database Discussion Boards

I would go for MySQL and C# as a final product.

Why not prototype with Access - for single user apps the form design etc is easy and fast.
Then when you are happy with what you are doing go for C# and MySQL - MySQL because it is open source and supported by Oracle.

I would avoid Access as a backend database if you can as MySQL is built specifically for the sort of thing you are trying to do(and Access most definitely is not...).

Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)

Yes, that is a good idea to get a prototype up, and also see if any design flaw. Thanks for the idea.

Stan Moong wrote:
3) Using C# for front-end and MS SQL Server Express as back-end.

I would choose this anyday. Access database is bound to get corrupted with multi-user access.

C Sharp and Ms access is best for your project.
or choose your db according to length of db.

Hi, I've been looking for an answer for quite a while but no luck, I'm sure u guys can help me out.
I have 3 tables
Roles > MId PK
Members > RId PK
Members_Roles (MId, RId)

I'm new to this so would appreciate ur help.

Regards,
K

You are going to have to post a real question in order to get an answer. However this[^] might be a starting point for you. Smile | :)

Chris Meech
I am Canadian. [heard in a local bar]

In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]

posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]

modified 4-Oct-11 15:02pm.

try this...........

select m.* from roles r, member m, member_roles p
where r.mid = p.rid and m.rid = p.rid

For an article I want to write I need a large sample database.
A bit like Northwind but with many records.

I could have based in on Northwind but I'd like to be able to use it (for comparison) on any database and not being in violation of Microsoft licenses.

I therefore wrote a script that create a few tables from scratch and a lot of data into it.
If you're mad enough to try it (you got the source below).
This is pretty much textbook to speak to database beginners but hopefully with enough relationship to make interesting queries.
It will create 5 classic tables (record count in the box):

      +- Client -+    +--Order----+
      |  100,000 |<---|   500,000 |
      +----------+    +-----------+  
           |                  ^
           |                  |
           v                  |
      +- Occupation-+         |
      |         330 |         |
      +-------------+         |
                              |
                              |
                              | 
+- Product -+           +--OrderLine--+
|     1,554 |<----------|   3,137,991 |
+-----------+           +-------------+

I hope you appeciate this fantastic Ascii-Art

I am trying to have a shortish script (a few kilobytes) that can quickly generate enough data to show the impact of indexes.
The script takes 6 minutes to run on my laptop

I worked hard on faking meaningful data.
This is one the first client looks like:

ClientId	1
FirstName:	Jimmy
MiddleName:	Lawrence
LastName:	Mcpherson
Gender:	M
DateOfBirth:	24:28.8
CreditRisk:	2
XCode:	AZ3 1KN
OccupationId:	228
TelephoneNumber:	(123) 822 - 3268
Street1:	468 Old Barnes Street
Street2:	2nd Floor
City:	Sacramento
ZipCode:	83319
Longitude:	38.46202086
Latitude:	120.999543
Notes:	In aute sunt et ea sed ex tempor. Et ex non eu anim ad. Id velit aliqua. Elit id do qui quis. Sed fugiat ex. Sunt ipsum ut eu ad sint. Enim magna animus lorem eu eu culpa. Sint nostrud irure ipsum amet amet. Sed do mollit irure nisi. Elit ut sint est ea culpa. Sit aute enim culpa deserunt ad ea. Eu velit et ex minim ad. Eu do enim non ad ad. Exclamo amet est. Nulla enim ex. Do ad ea ullamco ex. Magna excepteur ipsum ad non sunt eu non. Animus ut elit. Ut et est aute. Do cillum non ad sunt do enim. Ex non ea ea. Et id id sint duis. In in et. Id duis ipsum. Aute velit ut. Amet enim velit elit. Id occaecat ea. Sunt minim exclamo. Do ad et id id ipsum lorem. Qui qui do sunt ad. In exclamo do. Ipsum ad sed. Et ex ea. Et ullamco sunt nisi ex. Sunt eu quis lorem. Amet id sit ipsum. Non aute eu nisi. Ad et quis sed. Eu veniam nisi duis in sint non. Laboris sunt elit aute. Aliqua elit ad do. Culpa et ea. Esse in elit id. Ea ex elit. Est mollit ea nisi esse qui. Ad nisi in labore. Non ad veniam sed.

And this is the first product

ProductId: 1
Name: White fleece fabric
Price: 5.50
Active: 1
Stock: 319.740

If you got a minute or two (or 6) I am available for comments.
Would you format the database differently.
Is there enough data for proper real case scenarios?
http://pastebin.com/md3Sbr55[^]

Try Google for a large test database. I have seen various ones over the years but cannot remember where.

Hi,
How to take SQL Server backup automatically at a given schedule.

Thankyou,
YPKI

Have a read of this Maintenance plans[^]

Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

Are you using Express? If not look into SQL Server Agent Job.

write sql server job or sp for automatic backup and schedule it using sql server agent..

U must use the belowing link for your solution..
Automatic SQL Server Backup Utility using sqlserveragent[^]

Create a SP that will Take Backup of The Required dataBase

And Run The SP through SQl JOb

Hi Friends,

I am recently working on a Security and penetration testing project.I am able to get the Admin Page of the application.There are a lot of ways to proceed further now,can you suggest me some of the better way than others.
Database used is ORACLE and application developed in the aspx.

modified 4-Oct-11 2:39am.

Do you really think that someone is going to explain how to hack into a database and bypass the authentication so you can go and indulge in criminal activities? On a public forum?

Unrequited desire is character building. OriginalGriff

I am not indulging into any criminal activity,i also know the consequences and your concern is really appreciable. May be i am asking about dark area of IT.But if you can share some knowledge on it,it will be helpful.

Thanks

Nobody, is going to provide this sort of information on a public forum, even if they have it.

Unrequited desire is character building. OriginalGriff

If we do not share the information then how we can avoid attacks.I know public forum is that kind of place to share that kind of information but we can find some other way.

If intentions are good to improve the security features,then we can help each other,mode of communication can be different.

How do we know your intentions are good?

Unrequited desire is character building. OriginalGriff

This is the major drawback when we are talking to each other on a virtual environment that there is no button called "Trust Authentication".But i can only tell you that go through my profile on internet(Facebook:Search Harry kaizen Ivon) if you feel like,as i don't have any intentions check-o-meter to make someone believe that i am a good man with really good intentions to improve the holes in the systems.
Thanks for a great question.

The fact that you do not seem to understand the issues here speaks volumes about your suitability for the task you are asking about.

Unrequited desire is character building. OriginalGriff

There is an obvious test to try - however I am not going to tell you because:

(1)Anyone with any serious experience of databases will know about this.
(2)If you are working on a security testing project and are having to ask this question then you should not be on that project.
(3)As others have said how can we trust your intentions?

[edit ] in your favour with regards to (1) I have come across a few 'experienced' DBA's who themselves have not heard about this 'feature'...

Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)

modified 3-Oct-11 4:31am.