SQL Developer Suite

A tool use to generated Huge amount of fake data for your Practice

 

Create a Bland Database SQL2 

Create Table under this Database ‘People’

 

 

 

Use the application called Redgate to install and generate data for us.

• Open Url: https://www.red-gate.com/products/
• Scroll Down and download tool ‘SQL Data Generator’
• Get free trial, fill required information and download EXE
• Install ‘SQL Data Generator’ at your system  (SQLToolbeltEssentials)
  • 
  • Continue with rest of steps and let it install

 

Once installed click continue to create 50000000 records for you

• Search and start 
  • 
  • Sign in to start your trial 
  • Map with your database SQL2 and Table People
    • This will crate project for your database
  • As to generate 50000000 records for  you
    • 
    • Ask to Generate data for your table
      • 

 

 

• At the end it shows you report
  • 

 

 

Cross check People Data table records at you sql  (SSMS), SQL2 Database

• select count(*) from People
• 

 

 

Check the size of  your Database

• sp_helpdb [SQL2]
• 

 

 

 

Do Backup of your Database

BACKUP DATABASE [SQL2]
TO DISK = N'D:\SQLDBBACKUP\SQL2.BAK'
WITH NOFORMAT,
NOINIT,
NAME =N'SQL2-FULL DATABSE BACKUP',
SKIP, NOREWIND, NOUNLOAD, STATS=10
GO