Linked Questions
22 questions linked to/from Copy tables from one database to another in SQL Server
0 votes
1 answer
1k views
SQL Cross-Database Query [duplicate]
Possible Duplicate: Copy tables from one database to another in SQL Server I am trying to copy the data of one table into another table and both are of different Database say DB1 and DB2.Tables to ...
-1 votes
1 answer
364 views
How do I copy data from one table to an empty table in different databases? [duplicate]
I have two tables, 2012 and 2018, each in different databases. I am currently using SQL Server. The 2012 table has data filled in, while the 2018 table has the same exact columns, but is empty. I want ...
111 votes
10 answers
480k views
Transfer data from one database to another database
How to fetch the data from one database and insert in to another database table? I can't to do this. Please help me in transferring data from one to another.
27 votes
12 answers
163k views
Copy table from one database to another
I've just created an empty database on my machine. I now wish to copy a table from our server database to this local database. What sql commands do I need to run to do this? I wish to create the new ...
11 votes
7 answers
90k views
SQL Server Copying tables from one database to another
I have two databases, one is called Natalie_playground and one is called LiveDB. Since I want to practice insert, update things, I want to copy some of the tables from the LiveDB to Natalie_playground....
11 votes
4 answers
60k views
copy tables with data to another database in SQL Server 2008
I have to copy the tables with data from one database to another using Query. I know how to copy tables with data within a database. But I was not sure about how to do the same for copying between two ...
2 votes
5 answers
2k views
How to transfer data between different DB servers - No SSIS, No LinkedServer
How can I tranfer data between different DB Servers, this is a daily job, i.e: Insert into ServerA..table1 select data from ServerB.table2. (this is just an example, the real situation is we ...
2 votes
2 answers
1k views
How to copy datatable into SQL Server?
I need to copy a datatable into a new SQL Server table. I don't have any schema but I know what columns the datatable has (Year,Month,Day,MeanTemp,TotalPrecip,MaxGustSpeed) From my researches I found ...
1 vote
1 answer
1k views
Insert data from one database to another database if record does not exist
I've been searching for a couple of days and couldn't find a way to copy data from 1 database to another database. I've referred to Copy tables from one database to another in SQL Server and How to ...
0 votes
3 answers
1k views
Trying to copy one table from another database to another in SQL Server 2008 R2
i am trying to copy table information from a backup dummy database to our live sql database(as an accident happened in our program, Visma Business, where someone managed to overwrite 1300 customer ...
1 vote
0 answers
1k views
Copy a table with data to another db in SQL server 2005 express
I have a database with a table. I want copy it along with the data to another database. How can I do this in SQL server 2005 express?
0 votes
2 answers
808 views
Synchronize Data from serverDB to Local DB
I would like to get all the details of a single table from Remote server DB to my local DB, during page load event which should happen as a back end process can any one help me over this issue. NOTE: ...
0 votes
1 answer
739 views
mvc ef6 migration history deleted, want to restore but keep data
I am working on a ef6 mvc projeect and i deleted all migration records. I want to continue on the project with the current dj. I have a lot of data in there. I added an initial migration but I can't ...
-1 votes
4 answers
505 views
How to insert data from one table to other table in sql server [closed]
I have two sqlserver database both having same database and tables structure now I want to insert data from one specific table to other database table, both database table having same structure but ...
0 votes
2 answers
309 views
Error when using the instance name in query in SQL Server
I have two databases, both on the same server the default is named XXX the second is XXX\MSSQKSERVERVIS7 I need to copy a table from the second db to the default. When I attempt to use the server ...