Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Accessing sql 2005 and sql 2008

Status
Not open for further replies.
OldSlowDog

OldSlowDog

Programmer
Mar 11, 2002
36
US
Thank you for helping.
I have a need to read a sql 2005 table and do something with the data and insert the records to a sql 2008 table all in one c# program.
Is it possible for a C# program to access 2 versions of SQL? If not, would you please give me some suggestions.
Thanks again.
 
Sort by date Sort by votes
This is not a problem at all. using ADO.Net you would create a connection for each database. select from 05, insert/update to 08.

Jason Meckley
Programmer
Specialty Bakers, Inc.

faq855-7190
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

diembi
  • Locked
  • Question
sql server script error
Replies
0
Views
1K
diembi
diembi
NoCoolHandle
  • Locked
  • Question
working with SQL "FOR JSON AUTO
Replies
2
Views
1K
NoCoolHandle
NoCoolHandle
xarzu
  • Locked
  • Question
What is the proper way to declare a Microsoft class to use in my code. The quick and dirty way I am doing it here, I know, is not correct
Replies
0
Views
1K
xarzu
xarzu
hoangluc19
  • Locked
  • Question
Load hour and minute to datagridview C#
Replies
0
Views
1K
hoangluc19
hoangluc19
hoangluc19
  • Locked
  • Question
Create gridview meeting room and meeting time
Replies
2
Views
1K
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top