How can we select some data from a table in DB1 and insert into table in DB2 in Azure sql Server without using Azure Data Factory ? I have searched the internet and I found about using SSMS to generate query for data and run that query in DB2 but the problem is that data is too huge to do so, also tried doing a python script by making connections between databases but python is not able to allocate such huge memory. Note : It's different than usual SQL servers where simple select and insert works by using db names at the start, azure doesn't allow you to do so.
Copying specific data from one db to another in Azure Sql Db
168 Views Asked by Shadow At
1
There are 1 best solutions below
Related Questions in DATABASE
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- How to not load all database records in my TListbox in Firemonkey Delphi XE8
- microsoft odbc driver manager data source name not found and no default driver specified
- Cloud Connection with Java Window application
- Automatic background scan if user edit column?
- Jmeter JDBC Connection Configuration Parametrization of Database URL for accessing SQL Database
- How to grant privileges to current user
- MySQL: Insert a new row at a specific primary key, or alternately, bump all subsequent rows down?
- Inserting and returning autoidentity in SQLite3
- Architecture: Multiple Mongo databases+connections vs multiple collections with Express
- SQL - Adding a flag based on results within a query - best practice?
- Android database query not returning any results
- Developing a search and tag heavy website
- Oracle stored procedure wrapping compile error with inline comments
- Problems communicating with mysql in php
Related Questions in AZURE-SQL-DATABASE
- Data execution plan ended with error on DB restore
- Azure Data Factory: LinkedService for AzureSql in failed state
- Data streams in case of Merge
- How to get sql data bases instances in azure using java api
- How can I deploy an app using Identity Model to Production on Azure?
- Fatal error: Call to undefined function sqlsrv_connect() in C:\xampp\htdocs
- How do you get the Id field for a newly inserted item using the .NET client for Azure Mobile
- SqlCommandBuilder() creates insert/update for underlying tables instead for a view
- Bulk insert using code first migrations for azure
- Cannot enable Full-Text search on Azure SQL Database V12
- Azure data sync not syncing sql database data properly as expected
- Using MVC App to run CRUD operations on Existing Azure Database
- Sql Server Data Tools Data Comparison fails when connecting to Azure
- ShardMapManager.TryGetRangeShardMap wont retrieve the RangeShardMap
- Always Get 1 record from Table 2 based on some condition
Related Questions in DATA-MIGRATION
- Unpivot dynamic table columns into key value rows
- How to transfer a structure from one Plone to another
- MySQL structure migration
- What is causing my images to corrupt during FTP transfer to Go Daddy server?
- Django 1.8 How Drop certain tables using manage.py?
- Insert rows returned by stored procedure into a different table - different databases and servers
- Netezza to SQL Server Data migration
- Oracle Data Migration best usage in isolated servers
- App install, with a change in the Core Data model
- accessing model manager methods in datamigration
- 1 parameter, 2 given in ... after migrating from localhost
- How to migrate data to one table to another in MySQL
- Moving Nexus Repository, Backup Only Certain Artifacts?
- Migrating to MongoDb?
- Load balancing strategy for data reading and writing cluster
Related Questions in AZURE-SQL-SERVER
- Looking for a definitive Azure Sql Database sizing guide
- Azure Data Lake External Data Source: Row size is too big
- Azure ML Import Data connection has special character in password
- External table in Blob Storage in Azure SQL(Not Azure SQL DW)
- how to find if replication role of Azure SQL database
- How to deny port 1433 access to SQL Server VM while allowing SQL query from Integrated Web App
- Is there downtime while Scaling Azure SQL Elastic Pool Storage?
- MS SQL trigger not inserting records for bulk insert
- Azure ARM Template - SQL Failover Group Error FailoverGroupCreateOrUpdateRequestReadOnlyPropertyModified
- Unable to connect to Azure SQL through Virtual Network Gateway
- Calling Azure SQL Database REST API gives the error: The authentication scheme of Basic is not supported
- Azure Sql database export to Azure blob storage failed
- How to save a stored procedure into Azure SQL Server
- In Azure SQL Server How do I Query a table in db_1 from db_2 and insert records in table in db_2
- Is there any circumstance in which the DbConnection.ConnectionTimeout can be exceeded when executing Open() method?
Related Questions in CROSS-DATABASE
- PostgreSQL: how to periodically copy many tables from one database to another
- Zend Framework 2 cross database joins
- connecting to another db from one server
- SQL Server: avoiding hard coding of database name in cross-database views
- How to update table records in a database based on a table with the same table in another database?
- Join multiple databases in one View -- SQL Server Mangement Studio
- How to Handle Trigger-Driven Cross-Database Record Transfer with Nonexistent Users in SQL Server
- Codeigniter Datamapper Cross-Database Joins
- Is there any shortcut for using dblink in Postgres?
- Cross-database execution of Stored Procedure
- How to use cross DB join in CakePHP where database have prefix
- SQL Server Replication (cross-database queries & constraints)
- EntityFramework: Retrieve data with a condition on two different context
- SQL Server 2019 cross-database function call permission
- Copying specific data from one db to another in Azure Sql Db
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
I tried using SSIS, I created OLEDB Source and OLEDB Destination and did the migration, it was fast and easy. So to answer my own question, SSIS is useful in this case.