SQL SERVER – Copy Database from Instance to Another Instance – Copy Paste in SQL Server

SQL Server has feature which copy database from one database to another database and it can be automated as well using SSIS.

Make sure you have SQL Server Agent Turned on as this feature will create a job. The same job will execute the task. Make sure that SSIS is properly configured as well with necessary security permissions. You can automate this process as well control error logging.

Following are the steps to copy database from one instance to another instance.


Specify Source Server

Specify Destination Server

Here you can select option if you want to keep the database ONLINE when it is being copied.

You can also select option of MOVE or COPY database as well.


Give appropriate database name.

On this screen you can select additional options to copy as well.

You create the package over here.

You can schedule the package using SQL Server Agent.


When this process is over it will show the success message and database will be copied to another server.

You can see how easy is the process to copy the database to another server.

Watch SQL in Sixty Seconds Episode on same subject.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads

SQL SERVER – Generate Database Script for SQL Azure

When talking about SQL Azure the common complain I hear is that the script generated from stand-along SQL Server database is not compatible with SQL Azure. This was true for some time for sure but not any more. If you have SQL Server 2008 R2 installed you can follow the guideline below to generate script which is compatible with SQL Azure.

As above images are very clear I will not write more about them. SQL Azure does not support filegroups. Let us generate script for any table created on PRIMARY filegroup for standalong SQL Server and compare it with the script generated for SQL Azure.

You can clearly see that there is no filegroup in the code generated for SQL Azure. Give it a try and please your comment here about what do you think about the same.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Whitepaper – SQL Azure vs. SQL Server

SQL Server and SQL Azure are two Microsoft Products which goes almost together. There are plenty of misconceptions about SQL Azure. I have seen enough developers not planning for SQL Azure because they are not sure what exactly they are getting into. Some are confused thinking Azure is not powerful enough. I disagree and strongly urge all of you to read following white paper written and published by Microsoft.

SQL Azure vs. SQL Server by Dinakar Nethi, Niraj Nagrani

SQL Azure Database is a cloud-based relational database service from Microsoft. SQL Azure provides relational database functionality as a utility service. Cloud-based database solutions such as SQL Azure can provide many benefits, including rapid provisioning, cost-effective scalability, high availability, and reduced management overhead. This paper compares SQL Azure Database with SQL Server in terms of logical administration vs. physical administration, provisioning, Transact-SQL support, data storage, SSIS, along with other features and capabilities.

The content of this white paper is as following:

  • Similarities and Differences
    • Logical Administration vs. Physical Administration
    • Provisioning
    • Transact-SQL Support
    • Features and Types
  • Key Benefits of the Service
    • Self-Managing
    • High Availability
    • Scalability
    • Familiar Development Model
    • Relational Data Model

The above summary text is taken from white paper itself.

Reference: Pinal Dave (http://blog.sqlauthority.com)

SQLAuthority News – Community Tech Days – Jan 30, 2010 – Must Attend

Attend deep technology sessions for developers and IT professionals, as some of the best-known names come to your city to share their insights in topics ranging from .Net, Visual studio, Silverlight, to Windows and SQL Server. Build connections with Microsoft experts and community members and gain the inspiration and skills needed to maximize your impact on your organization while enhancing your career.

In Ahmedabad this event will happen on January 30, 2010. Just like last event we are expecting this time as well the event will have astonishing success and huge response. We will have five tech sessions back to back with lots of interesting and innovative efficient Microsoft products. The details of the sessions for this event is as following.

I will be talking about SQL Azure.

Microsoft SQL Azure Platform provide all the necessary building database blocks to develop and host rich database applications that can service an Internet-scale user population while storing nearly limitless amounts of data.

The venue for this event is Bhaikaka Hall, located at the center of the city. The complete address of the venue is Bhai Kaka Hall, Nr British Library, Nr Law Garden, Navrangpura, Ahmedabad – 380009. Please arrive early to secure your place. Last time we had many users showed up at very last moment and we were not able to accommodate after 300+ count. The onsite registration will start at 9:30 AM on January 30, 2010.

Register for this event here

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Download Windows Azure Platform Training Kit – December Update

Note :  Download Windows Azure Platform Training Kit – December Update by Microsoft

I wanted to read some good SQL Azure related to documentation, I tried to do searching online. While searching I landed over Windows Azure Platform Training Kit. This contains lots of SQL Server related content.I downloaded it and started to explore, I suggest if you are interested in Azure Platform you download it as well.

The Azure Services Training Kit includes a comprehensive set of technical content including hands-on labs, presentations, and demos that are designed to help you learn how to use the Windows Azure platform including: Windows Azure, SQL Azure and AppFabric. The December release includes new and updated labs in addition to information about Microsoft Codename “Dallas”.

This training kit contains lots of Hands On Labs, Presentations and Videos, Demos and Samples and Tools.

Download Windows Azure Platform Training Kit – December Update

Abstract courtesy : Microsoft

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Download – Microsoft Sync Framework Power Pack for SQL Azure November CTP (32-bit)

This release features the SQL Azure provider for Microsoft Sync Framework, a plug-in for Visual Studio 2008 Professional SP1 and the tool SQL Azure Data Sync Tool for SQL Server, all of which simplify using Sync Framework and SQL Azure together.

Download Microsoft Sync Framework Power Pack for SQL Azure November CTP (32-bit)

Abstract courtesy : Microsoft

Reference: Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Microsoft SQL Server Migration Assistant 2008 for MySQL v1.0 CTP1

Microsoft SQL Server Migration Assistant (SSMA) 2008 is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2008 and SQL Azure.

Download Microsoft SQL Server Migration Assistant 2008 for MySQL v1.0 CTP1

Abstract courtesy : Microsoft

Reference: Pinal Dave (http://blog.SQLAuthority.com)