How to use copy a table to another database table

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

Hi i want to copy a table to another database table using

SQL

Select * into DestinationDB.dbo.tableName from SourceDB.dbo.SourceTable

statement in SQL according to this article: Copy Table Schema and Data From One Database to Another Database in SQL Server
The thing is, i want to use a parameter for a table name instead of giving it from the statement like this:

SQL

SELECT * INTO DestinationDatabase.dbo."@copiedTableName" FROM SourceDatabase.dbo."@copiedTableName"

But apparently i can't use a parameterized table name for SourceDatabase. Any other ways to do it with table name parameter? Thanks in advance.

Posted 8-Sep-14 1:00am

YourAverageCoder

Add a Solution

2 solutions

Solution 1

i dont know about table copy,

but you can read data from first one and insert the read data to the second table.

read one{
put data in an array.
}

insert data to the second table
use for loop.

Posted 8-Sep-14 1:06am

MariwanIT

Comments

Herman<T>.Instance 8-Sep-14 7:23am

slow in performance when copying large tables

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

hypermellow · Accepted Answer · 2014-09-08T01:10:00

Solution 2

Have a look at MSSQL's procedure sp_executesql.

sp_executesql allows you create a dynamic string containing the SQL statement to run, so you should be able to incorporate you dynamic table name into the SQL statement.

Hope it helps.

Posted 8-Sep-14 1:10am

hypermellow