Because of a legacy program, and for now until I have the time to implement something else, I need to transfer data from a SQL Server database on a server to a local SQL Express 2014 database temporary table.
This was previously being done by importing data from a SQL Server DB to a JET 4/ACEDAO 2010 mdb, coded with in the application:
Code:
oConn.Connection = "Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=SomeDatabase.Mdb;"
oConn.Open
sql = "INSERT INTO " & _
"[SomeTable] " & _
"SELECT * FROM " & _
"[ODBC;Driver=SQL Server; " & _
"SERVER=MYSERVER\MYINSTANCE;DATABASE=MyDatabase;" & _
";Integrated Security=SSPI;]." & _
"[LOH];"
oConn.Execute sql
Once the temporary user specific data is in "SomeDatabase.Mdb", which is in a Windows user profile AppData, it is processed further by a different program.
Now I want to upgrade "SomeDatabase.Mdb" to a local SQL Server Express database.
Is this possible?