SELECT INTO or CREATE TABLE

[bxlorenz]

I have a SQL 2005 database and a SQL 2008 database. I want a simple SQL statement that will create/copy a table and its contents from 2005 into 2008 that I can use in a C# program. I know I can export using Mgmt Studio but I want to do in a a program. I am able to perform a SELECT INTO [MyDatabase2].[dbo].[mytable] SELECT * FROM [Mydatabase1].[dbo].[mytable] when they exist in different databases in the same machine and only in the same Database Instance but how do I across multiple instances or multiple machines. Can anyone help ? Thanks

[Not Active]

bxlorenz wrote:

I can use in a C# program.

Why would you want to do this in C#? Why use in-line SQL statement X| You'd be better off writing an SSIS package or at least a stored procedure. You also need create the linked servers in your SQL instance to go between machines and instances. BTW, this has nothing to do with Linq, why did you choose this forum rather then the Database forum?

---

only two letters away from being an asset

[bxlorenz]

Well, I already have a C# program that connects to the databases on different systems to perform some conversions of data from different tables which are not same structure. However I do have several tables that are identical and want to just create and copy entire data over as well. I know I could create the table and then perform select and insert, I just want a simple was to perform all at once without haiving to read the table and then the columns and create a new table based off it. Not familiar with SSIS packacge and linking servers. Again just looking to convert data over from one system to another based on certain data selected, but preserve some tables as is. thnx

[Thanigainathan S]

Well you should be using SqlBulk Copy Command[^]

India is Mythical and so we are

[bxlorenz]

So what would be the exact syntax if I am connecting to two different Systems running SQL 2005 and 2008 and using to different instances and databases ? Thanks