conversion

26 Mar 2007 8:09 PM

Luuk

Hi all,

I want a good tool to write scripts with to convert data from a MSSQL
database to any other database (possibly, but no neccasarily, also MSSQL)

Anyone have any good ideas?

--
Luuk

26 Mar 2007 11:32 PM

Andrew J. Kelly

Well SQL Server has built in tools for that. IN SQL2000 it is called DTS and
in 2005 it is SSIS. I would check BooksOnLine for more information.

--
Andrew J. Kelly SQL MVP

Show quote

"Luuk" <l***@invalid.lan> wrote in message
news:4608286a$0$329$e4fe514c@news.xs4all.nl...
> Hi all,
>
> I want a good tool to write scripts with to convert data from a MSSQL
> database to any other database (possibly, but no neccasarily, also MSSQL)
>
> Anyone have any good ideas?
>
> --
> Luuk
>

27 Mar 2007 7:30 PM

Luuk

Show quote

"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> schreef in bericht
news:O5FlD8$bHHA.4616@TK2MSFTNGP03.phx.gbl...
> Well SQL Server has built in tools for that. IN SQL2000 it is called DTS
> and in 2005 it is SSIS. I would check BooksOnLine for more information.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Luuk" <l***@invalid.lan> wrote in message
> news:4608286a$0$329$e4fe514c@news.xs4all.nl...
>> Hi all,
>>
>> I want a good tool to write scripts with to convert data from a MSSQL
>> database to any other database (possibly, but no neccasarily, also
>> MSSQL)
>>
>> Anyone have any good ideas?
>>
>> --
>> Luuk
>>
>
>

so, i have to investigate DTS, and after that i have to investigate SSIS, an
after that ...... ;-(

?