58 How to dynamically move multiple sql tables from one server to another

how to dynamically move multiple sql tables from one server to another
Download the file\script used in the Video from below link

how to dynamically move multiple sql tables from one server to another
SQL Dynamic Query from multiple tables - Microsoft Q&A
Moving multiple tables between MS SQL Servers using only
Dynamically copy data from one table to another
Query from multiple tables dynamically - sql - Stack Overflow
Creating Dynamic T-SQL to Move a SQL Server Database
Migrate Data from all tables from one database to another

Happy Learning.

[TheGargarpit]

thanks for the video, was able to transfer the data between different databases. I just made some changes in main function removing the argument inside it and removing the static keyword also.

[srinivasarao-grpv]

Can you please create and explain One Complex SSIS Package From starting to End. It's more helpful for every one. Thanks in advance

[Knowledgegreenone]

If possible can u make some videos as requirement stated for topics by this weekend as needed that your explanation is great.

[aspait]

could you please share the control flow diagram which all component u have used

[AshishPatel-knkc]

Is there way to Truncate and load data into different table than source, ? source and target table structure is same. how can we pass values from parameter

[aspait]

Hi dude .. i m able to do it without writing single line of code with the help of foreach and dft. I would like to share the step, just wanted to little contriubution in great effort

[aspait]

Hi, this is very good using the script but there might be some issue when we transfer big table, is there any inbuilt ssis copy activity we can use and make loop over it instead of we writing copy code in the script.

[nishanratnayake]

Thank you for posting this video. I am trying to copy several tables from one server to another. I am using your code. However when I run the SSIS package, I get an error. " can not execute the script because script entry point is invalid. When i hover over args, i can see the following message. "remove unused parameter args". Can you please help me to fix this error. When I change static void main( string[]args) to public void main(), the package runs without giving an error. But no table is created in destination server though i CopySQLTable(Tbl, true); Do I need to create tables in destination server manually first? This is the first part of my code. using System;
using System.Data;
using
using System.Windows.Forms;
using System.Data.SqlClient;
#endregion

namespace
{
/// <summary>
/// ScriptMain is the entry point class of the script. Do not change the name, attributes,
/// or parent of this class.
/// </summary>

public partial class ScriptMain :
{

static void Main(string[] args)
{
string ConfigConnectionString = "Server= SY-XXXDEV-01; Database= HXXX2_TEST;Integrated Security = SSPI; ";
string sql = "select SourceTable from ImportTableList";