Creating Scripts To Insert Data From Existing Tables

When we work with systems is inevitable to work with data that is manipulated by these, and there are moments when you need to move data created by one application to another database, but it's not necessary to copy all the database to another one, maybe you require just to move all data for particular tables.

For this task, SQL Server can help us by using the "Generate Scripts..." option that it's into Management Studio tool, you only have to right-click over the source database and go to "Tasks" menu and here locate the option said before.
 
Click on generate scripts for the database
 
You will see the introduction, just click "Next".

Next step in the wizard

As I said at the beginning in this opportunity we are going to select a group of tables and not all the database.

Select the objects to generate the scripts

Specify the media where this result is going to be published. But, in this case it is necessary to click on "Advanced" option to personalized the operation.

Select the script settings

As we want just the data, select "Data only" in the "Types of data to script".

Select the type of data to create the script

Review the summary of the operation to be executed.

Review all the settings before creating the scripts

Wait for the process to finish successfully.

Wait for the scripts to be generated

Once the process finishes with success the output file can be use directly over the new database that have the tables with no data.


Comments

  1. AnonymousDecember 9, 2013 at 12:32 AM

    Hello There. I found your blog using msn. This is a very well written article.
    I will make sure to bookmark it and return to read more of your
    useful info. Thanks for the post. I'll certainly return.


    Review my web-site - Free Minecraft Premium Account

    ReplyDelete

Post a Comment

Popular posts from this blog

I Need to Send an Automatic Email with Lotus Notes

Image
If you don't know, Lotus Notes is an email client used in a lot of companies around the world. Therefore, I use it at work everyday, but someday I needed to send an automatic email to a few people all Fridays at 10:00.   To get this task accomplished I decided to create an agent and avoid remembering the fact of sending the email. As you can image, I did this example on a Spanish version of Lotus Notes 8.5 but I will explain it clearly enough. The first step is getting yourself into the inbox, then select the "Create" menu item and inside of it, click on "Agent...". You will get a dialog box opened, in this we have the possibility of setting the rules for this agent. However, in this case we will only set "Trigger" option to "On schedule" with the "Weekly" frequency. Don't forget to push the "Schedule..." button to program the agent in the right way. After this, select "OK" and close the dialog bo...
Read more

Turn Horizontal Visio Swimlanes into Vertical Ones

Image
In one ocassion, a friend at work called me because she had a problem with Microsoft Visio , she was trying to draw a process flowchat but using swimlanes, this was not a problem until she realized that it would be better to use vertical swimlanes instead of horizontal ones.    But, when she tried to drag a vertical one it just put together to the previous swimlanes created before.  To avoid creating a new visio document and lost your work just go to 'Cross-Functional Flowchart' ribbon and select 'Orientation' and 'Vertical'.     And it's done, now you can work with vertical swimlanes or if you like it you can turn them back to horizontal ones.
Read more

Install TWRP Recovery in Xiaomi Redmi 6A

Image
Case: You try to install TWRP Recovery in your Xiaomi Redmi 6A, but the official process doesn't work. Requisites: Xiaomi Redmi 6A phone, USB cable, computer with Windows and TWRP Cactus Tools installed . Steps: Make sure the phone is connected to the computer and in debug mode.  Open TWRP Cactus Tools: Click 'Flash TWRP' and select the right TWRP (be careful with the Android version): Click 'Start Flash' Results: The flash will finish and your phone will have the TWRP recovery.
Read more