Linked Questions

0 votes
1 answer
1k views

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 ...
Khyati Sehgal's user avatar
-1 votes
1 answer
364 views

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 ...
Kyodi's user avatar
  • 31
111 votes
10 answers
480k views

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.
Bharathi's user avatar
  • 1,565
27 votes
12 answers
163k views

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 ...
Baz's user avatar
  • 13.3k
11 votes
7 answers
90k views

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....
Natalia Natalie's user avatar
11 votes
4 answers
60k views

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 ...
prabu R's user avatar
  • 2,209
2 votes
5 answers
2k views

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 ...
Guoliang's user avatar
  • 895
2 votes
2 answers
1k views

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 ...
Febe's user avatar
  • 21
1 vote
1 answer
1k views

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 ...
TheButterfly's user avatar
0 votes
3 answers
1k views

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 ...
Tommy's user avatar
  • 83
1 vote
0 answers
1k views

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?
Luca Romagnoli's user avatar
0 votes
2 answers
808 views

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: ...
faroke moahmed's user avatar
0 votes
1 answer
739 views

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 ...
Marijn's user avatar
  • 81
-1 votes
4 answers
505 views

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 ...
Neeraj Kumar Gupta's user avatar
0 votes
2 answers
309 views

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 ...
Terry S's user avatar
  • 23

15 30 50 per page