Advertisements

Copy Or Generate SQL Database Content To Multiple One


Introduction

In this article you will learn how to copy or generate SQL database content to multiple one.

Step 1: I have two database “Test1” & “Test2”. Test2 database is empty,  so we want to copy Test1 database to Test2 based on your requirement like MS SQL Server 2008, 2012, etc.

1

Step 2: Generate the “Test1” database script based on the following steps:

  • Right click “Test1” database.
  • Click Tasks, then Generate Scripts.

2

Step 3 : Click Next..

3

Step 4 : Select “Select specific database objects” and check all the tables present in the database.

4

Step 5 : Click “Advanced“, Open New Pop Up Window, General, Script for Server Version, click SQL Server2008 R2 ( Select based on your requirement ).

5

Step 6 : Click “Advanced“, Open New Pop Up Window, General, Types of data to script, then select Schema and data ( Select based on your requirement ).

6

Step 7 : Select the save location for generated script.

7

Step 8 : Click Next.

8

Step 9 : Click Finish.

9

Step 10 : Change database name and update the generated scripts.

10

Step 11 : Now copy “Test1” into “Test2”.

11

Summary

We learned how to copy or generate SQL database content to multiple one. I hope this article will be useful for beginners.

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: