|
| MIIS 2003 SP2-SQL 2K MA |
 |
Thu, 3 Apr 2008 13:53:03 -0700 |
Hi,
Is it possible to have the SQL MA import from one view in a SQL
database and export to another view in the same or different database?
I do not see any options available on the MA itself.
i.e.
Import from V1 in DB1
Export to V2 in DB1 OR Export to V3 in DB2....is this possible?
Thanks for your help in advance.
|
| Post Reply
|
| Re: MIIS 2003 SP2-SQL 2K MA |
 |
Fri, 04 Apr 2008 09:56:00 +020 |
dipti wrote:
> Hi,
>
> Is it possible to have the SQL MA import from one view in a SQL
> database and export to another view in the same or different database?
> I do not see any options available on the MA itself.
>
> i.e.
>
> Import from V1 in DB1
> Export to V2 in DB1 OR Export to V3 in DB2....is this possible?
>
No .. You can't do this ... this can be easily solved with custom
Extensible MA or You will have to configure two separate SQL MAs and
build some logic around this.
--
Tomasz Onyszko
http://www.w2k.pl/ - (PL)
|
| Post Reply
|
| Re: MIIS 2003 SP2-SQL 2K MA |
 |
Fri, 4 Apr 2008 13:43:34 -0700 |
Thanks Tomasz.
Please can you elaborate on using two SQL MAs to get around this.
Is it as simple as, one MA will do the import and sync and the other
will do the export?
|
| Post Reply
|
| Re: MIIS 2003 SP2-SQL 2K MA |
 |
Sat, 5 Apr 2008 19:34:29 -0700 |
|
| Post Reply
|
| Re: MIIS 2003 SP2-SQL 2K MA |
 |
Sat, 05 Apr 2008 21:16:06 +020 |
dipti wrote:
> Thanks Tomasz.
>
> Please can you elaborate on using two SQL MAs to get around this.
>
> Is it as simple as, one MA will do the import and sync and the other
> will do the export?
>
> Really appreciate your response..Thanks a lot.
yes .. this was exactly what I mean ... one MA will serve as import only
and will just read data ... other MA will do exports to other table ...
--
Tomasz Onyszko
http://www.w2k.pl/ - (PL)
|
| Post Reply
|
|
|
|
|
|
|
|
|
|