<div>
<div class="content wysiwyg-content">
Hi <br />
<br />
I have just created a Azure SQL account.<br />
<br />
Right now I have my data in an Microsoft SQL Server Enterprise Edition 8.0.2039 database.<br />
<br />
I want to copy all these tables (incl. all data) (quite a lot of tables!) to my new Azure SQL server.<br />
<br />
It gives different errors when I try to use the built-in export function in SQL Server Management Studio 2005/2008.<br />
<br />
Can you please help. What to do?
</div>
</div>


Hi 

I have just created a Azure SQL account.

Right now I have my data in an Microsoft SQL Server Enterprise Edition 8.0.2039 database.

I want to copy all these tables (incl. all data) (quite a lot of tables!) to my new Azure SQL server.

It gives different errors when I try to use the built-in export function in SQL Server Management Studio 2005/2008.

Can you please help. What to do?

From SQL Server to Azure

HTML (HyperText Markup Language) is the main markup language for creating web pages and other information to be displayed in a web browser, providing both the structure and content for what is sent from a web server through the use of tags. The current implementation of the HTML specification is HTML5.

HTML

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.