I have two separate databases and I would like to move a table from one database to another database. Is it possible to create a disconnected recordset in source table and then attached this recordset to destination database? Please advise. If not, any better generic approach?
ADODB recordset for migrate data
2 posts
• Page 1 of 1
- Win32 Programming
- tcl
- WINDOWS SERVER
- Exchange 2000
- MS OFFICE OUTLOOK
- shareware
- unix
- tex
- Microsoft Project
- Windows XP
Jump to:
- 1. Refresh Cache
Hi! I must be the last one on the planet to know. I use a JET database for a webpage. When I delete rows it doesn't reflect on the page. I assume it has to do with the caching of the JET object. Does anyone know how to refresh this stuff. I do not want to use JRO for as far as I can understand it requires a ADO conncetion (as opposed to a ADO.NET connection). Isn't it weird how hard it is to find onfo about this as it must be a major issue for all developers? Grateful for tips! !Robert PS I am using code like: System.Data.OleDb.OleDbConnection cn; cn = new System.Data.OleDb.OleDbConnection(); cn.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionString ").ToString(); cn.Open(); System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(); cmd.Connection = cn; - 2. Create Dataset
After adding a DataAdapter and then trying to use the Generate DataSet wizard, I'm getting a message that Visual Studio can't generate an instance of the DataSet with advice to be sure that class is a valid DataSet class. It is a valid class as best I can determine. I can generate an instance if I manually enter code; whay can't Visual Studio? -- Al S - 3. Hi Wlliam
I Would Like Know, If You Can Send Me A Message Mi Mail, where You Can Give A Recomendation.... Mi Mail is: XXXX@XXXXX.COM I Will be, Very Very Gratefull.... Thank You....
Next
ADODB recordset for migrate data
by Alex » Mon, 30 Jun 2003 23:52:51 GMT
Re: ADODB recordset for migrate data
by Val Mazur » Tue, 01 Jul 2003 22:16:20 GMT
Hi Alex, In case if one database is SQL Server you have good tool, which calls SQL DTS. It is fast way to transfer data between datasources. Yes, you also could create disconnected recordset and re-attach it to another DB, but it would require using of XML, since you need to modify recordset to *mark* records as inserted to be able to transfer them to another database. That way could be slow in case if database is very big. I have an example how to do that. If you need it, let me know by e-mail and I will send it to you. It is too big to post it here
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 8 guest