Resolve

issues faster

Database Tools

Must-have SQL Server tools and tools for MySQL, Oracle, and PostgreSQL database development, management and administration

Data Connectivity

The most trusted solutions for your data connectivity needs: ADO.NET, ODBC, SSIS, Excel, dbExpress, Delphi Components

Productivity Tools

Write code, create reviews, compare sources, track the working hours with the web app, utilize the power of ORM Solutions

Data Services

Data integration, online backup, web-based SQL tools, cloud connectivity solution

The Sales Database Sample Script

		CREATE DATABASE Sales_v1
     GO
     USE Sales_v1
     GO
     CREATE TABLE [Customers](
         [CustomerID] [int] NOT NULL CONSTRAINT [PK_Customers_CustomerID] 
           PRIMARY KEY CLUSTERED,
         [AccountID] [nvarchar](15) NOT NULL, 
         [Title] [nvarchar](8) NULL, 
         [FirstName] [nvarchar](30) NOT NULL,
         [MiddleName] [nvarchar](30) NULL,
         [LastName] [nvarchar](30) NOT NULL,
         [Suffix] [nvarchar](10) NULL, 
         [Address] [nvarchar](200) NULL,
     )
     GO
     INSERT INTO [Sales_v1].[dbo].[Customers]
                ([CustomerID],
                 [AccountID],
                 [Title],
                 [FirstName],
                 [MiddleName],
                 [LastName],
                 [Suffix],
                 [Address])
          VALUES
                (1,
                'ACC-1',
                'Mr',
                'Thomas',
                'James',
                'Smith',
                '',
                '')
     GO
     CREATE DATABASE Sales_v2
     GO
     USE Sales_v2
     GO
     CREATE TABLE [Customers](
         [CustomerID] [int] NOT NULL CONSTRAINT [PK_Customers_CustomerID] 
           PRIMARY KEY CLUSTERED,
         [AccountID] [nvarchar](15) NOT NULL, 
         [Title] [nvarchar](8) NULL, 
         [FirstName] [nvarchar](30) NOT NULL,
         [MiddleName] [nvarchar](30) NULL,
         [LastName] [nvarchar](30) NOT NULL,
         [Suffix] [nvarchar](10) NULL, 
         [Address] [nvarchar](200) NULL,
     )
     GO
     CREATE TABLE [Accounts](
         [AccountID] [nvarchar](15) NOT NULL CONSTRAINT [PK_Accounts_AccountID] 
           PRIMARY KEY CLUSTERED,
         [Status] [int] NOT NULL,
         [Services] [nvarchar](200) NULL
     )
     GO
     INSERT INTO [Sales_v2].[dbo].[Accounts]
                ([AccountID], 
                 [Status], 
                 [Services]
                 ) 
          VALUES (N'90128', 
                  0, 
                  N'Confections')
     GO
     ALTER TABLE [Customers] ADD 
         CONSTRAINT [FK_Customers_Accounts_AccountID] FOREIGN KEY 
         (
             [AccountID]
         ) REFERENCES [Accounts](
             [AccountID]
         )
     GO