Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ravininave
Posting Yak Master
111 Posts |
 Posted - 2010-11-25 : 14:38:16
|
| Hi All,I've Two Databases Access & Sql Server 2010.Actually we have client server application and having database in Access LocallyOur Another database is in Sql ServerWe have to copy some bunch of data from Access To Sql ServerBoth the database has the same fieldsHow to do it?VB6/ASP.NET------------------------http://www.nehasoftec.com |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-26 : 04:31:32
|
| ssis, linked tables and copy from access, linked server and copy from sql server, upgrade wizard.Whatever you do you will need to check the data is being transferred correctly.Especially check column sizes, dates, varchar vs nvarchar, any foreign or odd characters that might be in the tables, ...==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
MohanKandasamy
Starting Member
9 Posts |
Posted - 2010-11-27 : 09:22:49
|
| Hi, If iam not wrong and understand your question,i think you use client side access database and server side your sql server database.and you want to move the data between two database,in this case i can recomonded that instead of SSIS or link server, you can serialized the data into xml and sent to server to store the data via application.Mohan Kandasamy |
|
|
|
|
|
|
Copy Data Between Two Databases