ETL and Data Integration tools - Modern ETL software for everyone

Hello.

I am using MS aaccess as repository.
Is there any way to use sql server instead?

Phil

Of course you can do that.

Here is how.

All the scripts required are stored within default repository

Please follow the steps below to switch to SQL Server Repository

1. create new sql server database
2. Find Repository [SQL 2000] in objects tree
3 Change connection properties for Repository [SQL 2000] so it point to the database you created in step1
4 open sql script Create Repository Objects [SQL 2000] and run it using green arrorw.
5 Export repoisory into zip file Tools->Export repository
6 Connect to repository;
a. File->Options-> Set Repository Connection Name to Create Repository Objects [SQL 2000]
b. Click properies butto next to Connection Name.
c set connection properties so it points to the database you created at step one.
d. Click OK,Click Reconnect, Click OK, You are now connected to MS Sql Repository
7 Import repository from the file you create at step 5 Tools->Import repository

Done

John