Creation of sample data in database tool @ sqlserver

Question

I need a database tool where i can easily add information to it.

Example:

I have 2 tables, customers and invoices. The database tool must show me input fields of the customer and invoices. invoice has a foreign key to customer. The input fields of invoices must have a dropdown where i can select the customer so i won't have to copy paste the ID of the customer.

Ed Harper · Accepted Answer · 2009-10-22 08:16:50Z

1

The tags on your question suggest you may be creating test data. Have you considered a tool like RedGate's Data Generator?

answered Oct 22, 2009 at 8:16

Ed Harper

21.6k5 gold badges60 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Heinzi · Accepted Answer · 2009-10-22 08:18:02Z

0

If you want to enter the sample data manually (that's how I understood your question), Microsoft Access sounds like the tool of choice here:

Create a new Access DB and link to the SQL Server tables. Enter the customers directly in Table view. For the invoices, use the wizard to create a form, then create a combobox that references to the customers table.

answered Oct 22, 2009 at 8:18

Heinzi

173k61 gold badges386 silver badges554 bronze badges

Collectives™ on Stack Overflow

Creation of sample data in database tool @ sqlserver

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related