I have a C# program that has a connection to 2 different databases across 2 different SQL servers. How can I easily copy a table and all its contents from one database to another using SQL statements in C# I do not want to use the management studio to perform this and want to do it in my C# program. Any help would be appreciated. Thanks

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

Blikkies, Thanks for the info. Just a couple follow up questions. So on the 2005 SQLExpress Server I have an instance of SQLEXPRESS and on 2008 SQL I have an DB instance of MY2008DB I would do the following if I am running on the 2008 system. EXEC sp_addlinkedsrvlogin '\\MY2005Server\SQLEXPRESS', 'false', 'sa', 'sa', 'sa' SELECT INTO [MyDatabase2].[dbo].[mytable] FROM [\\MY2005Server\SQLEXPRESS].[Mydatabase1].[dbo].[mytable] and if I was running this on the 2005 server it would be the opposite ? EXEC sp_addlinkedsrvlogin '\\MY2008Server\MY2008DB', 'false', 'sa', 'sa', 'sa' SELECT INTO [\\MY2008Server\MY2008DB].[MyDatabase2].[dbo].[mytable] FROM [Mydatabase1].[dbo].[mytable] Or how does that work with the DB Instance name ? thanks

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

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

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

I want to Iterate thru a listBox and write the strings to a file. I have the following code that worked in VS 2005 but does not compile in VS 2008 StreamWriter f = new StreamWriter(fn); IEnumerator eEnum = this.mylistBox.Items.GetEnumerator(); if (eEnum != null) while (eEnum.MoveNext()) f.WriteLine((String) eEnum.Current); f.Close(); In VS 2008 I get a compile error saying Using the generic type 'System.Collections.Generic.IEnumerator' requires '1' type arguments Can someone explain ?