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 |
|
joshiriddhi
Starting Member
2 Posts |
 Posted - 2008-07-23 : 11:38:06
|
| Hi,I want to transfer data from MS SQL Server to LinkSQL database. How can I go about doing that. I know if I want to transfer data within the same type of database, I can use dblink. Please help.Thanks,Riddhi. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-23 : 11:42:33
|
| You can use SSIS or DTS export import wizard to transfer data b/w them. just define two connection strings one each for SQL Server and LinkSQL and use export import wizard to transfer data. |
 |
|
|
joshiriddhi
Starting Member
2 Posts |
Posted - 2008-07-23 : 11:49:49
|
| The process can't be manual. We are having a manual process right now.My manager wants something done on lines of - getting the data in a file and mapping it to the LinkSQL database. I am not sure how.I really appreciate your prompt response.Riddhi. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-23 : 11:54:40
|
quote:
Originally posted by joshiriddhi
The process can't be manual. We are having a manual process right now.My manager wants something done on lines of - getting the data in a file and mapping it to the LinkSQL database. I am not sure how.I really appreciate your prompt response.Riddhi.
create a package that does the transfer as posted earlier. then add a sql job to execute the package according to your convienience by specifying a schedule. |
|
|
|
|
|
|
Data Transfer from MS SQL server to LinkSQL