I haven't installed this yet but does anyone who has have any comments on
the pros and cons vs. SQL2005 Express?
Also, does it have any graphical management tools (analogous to Mgt. Studio
Express)?
Many thanks.
No one knows, huh?
"Andrew Chalk" <achalk@.magnacartasoftware.com> wrote in message
news:erEAtjYAGHA.3840@.TK2MSFTNGP15.phx.gbl...
>I haven't installed this yet but does anyone who has have any comments on
>the pros and cons vs. SQL2005 Express?
> Also, does it have any graphical management tools (analogous to Mgt.
> Studio Express)?
> Many thanks.
>
Showing posts with label sql2005. Show all posts
Showing posts with label sql2005. Show all posts
Monday, March 19, 2012
Monday, March 12, 2012
Oracle to SQL 2005 Replication
Greetings,
I am looking for a tool that i can use to replicate oracle tables into Sql
2005 database. Or if i can pull the data out of oracle using a sql tool that
would be perfect. The database tables are only 2GB or so. Can someone share
some insight on whether this is feasible or not.
Thanks In Advance
Deon
Transactional replication for Oracle Publishers (v 8.0.5 upwards) is built on
the Microsoft SQL Server transactional replication publishing architecture
for SQL 2005.
Pls have a look in BOL for more details.
Cheers,
Paul Ibison
|||Thanks Paul.
What is BOL?
"Paul Ibison" wrote:
> Transactional replication for Oracle Publishers (v 8.0.5 upwards) is built on
> the Microsoft SQL Server transactional replication publishing architecture
> for SQL 2005.
> Pls have a look in BOL for more details.
> Cheers,
> Paul Ibison
I am looking for a tool that i can use to replicate oracle tables into Sql
2005 database. Or if i can pull the data out of oracle using a sql tool that
would be perfect. The database tables are only 2GB or so. Can someone share
some insight on whether this is feasible or not.
Thanks In Advance
Deon
Transactional replication for Oracle Publishers (v 8.0.5 upwards) is built on
the Microsoft SQL Server transactional replication publishing architecture
for SQL 2005.
Pls have a look in BOL for more details.
Cheers,
Paul Ibison
|||Thanks Paul.
What is BOL?
"Paul Ibison" wrote:
> Transactional replication for Oracle Publishers (v 8.0.5 upwards) is built on
> the Microsoft SQL Server transactional replication publishing architecture
> for SQL 2005.
> Pls have a look in BOL for more details.
> Cheers,
> Paul Ibison
Monday, February 20, 2012
Oracle connection from a SQL2005 Ent. Edt. X64 cluster
Hi
Does anybody know if there is a problem/issue with retrieving data from
Oracle on a SQL2005 Cluster? My problem is that I don't seems to have
the MSDAORA provider like I have on my other servers.
I don't recall having ever seen this not being present in a SQL
installation, so I'm wondering if this has something to do with the fact
that it's a Cluster install?
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote in
message news:uAWzvoJYHHA.4232@.TK2MSFTNGP05.phx.gbl...
> Hi
> Does anybody know if there is a problem/issue with retrieving data from
> Oracle on a SQL2005 Cluster? My problem is that I don't seems to have the
> MSDAORA provider like I have on my other servers.
> I don't recall having ever seen this not being present in a SQL
> installation, so I'm wondering if this has something to do with the fact
> that it's a Cluster install?
>
There is no 64bit version of the MSDAORA provider. You will need the OleDB
Provider from Oracle. Get version 10.2.0.2.
David|||David Browne wrote:
>
> ""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote
> in message news:uAWzvoJYHHA.4232@.TK2MSFTNGP05.phx.gbl...
>> Hi
>> Does anybody know if there is a problem/issue with retrieving data
>> from Oracle on a SQL2005 Cluster? My problem is that I don't seems to
>> have the MSDAORA provider like I have on my other servers.
>> I don't recall having ever seen this not being present in a SQL
>> installation, so I'm wondering if this has something to do with the
>> fact that it's a Cluster install?
> There is no 64bit version of the MSDAORA provider. You will need the
> OleDB Provider from Oracle. Get version 10.2.0.2.
> David
Hi David,
Thanks for the info. I'll try to get it working with the Oracle OLEDB
provider. I've never used that one, so do you by any change have any
links that tells about how to install/configure it?
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote in
message news:e1CkGmMYHHA.4232@.TK2MSFTNGP05.phx.gbl...
> David Browne wrote:
>>
>> ""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote
>> in message news:uAWzvoJYHHA.4232@.TK2MSFTNGP05.phx.gbl...
>> Hi
>> Does anybody know if there is a problem/issue with retrieving data from
>> Oracle on a SQL2005 Cluster? My problem is that I don't seems to have
>> the MSDAORA provider like I have on my other servers.
>> I don't recall having ever seen this not being present in a SQL
>> installation, so I'm wondering if this has something to do with the fact
>> that it's a Cluster install?
>>
>> There is no 64bit version of the MSDAORA provider. You will need the
>> OleDB Provider from Oracle. Get version 10.2.0.2.
>> David
> Hi David,
> Thanks for the info. I'll try to get it working with the Oracle OLEDB
> provider. I've never used that one, so do you by any change have any links
> that tells about how to install/configure it?
>
Oracle Provider for OLE DB
http://www.oracle.com/technology/tech/windows/ole_db/index.html
David|||David Browne wrote:
>
> ""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote
> in message news:e1CkGmMYHHA.4232@.TK2MSFTNGP05.phx.gbl...
>> David Browne wrote:
>>
>> ""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk>
>> wrote in message news:uAWzvoJYHHA.4232@.TK2MSFTNGP05.phx.gbl...
>> Hi
>> Does anybody know if there is a problem/issue with retrieving data
>> from Oracle on a SQL2005 Cluster? My problem is that I don't seems
>> to have the MSDAORA provider like I have on my other servers.
>> I don't recall having ever seen this not being present in a SQL
>> installation, so I'm wondering if this has something to do with the
>> fact that it's a Cluster install?
>>
>> There is no 64bit version of the MSDAORA provider. You will need the
>> OleDB Provider from Oracle. Get version 10.2.0.2.
>> David
>> Hi David,
>> Thanks for the info. I'll try to get it working with the Oracle OLEDB
>> provider. I've never used that one, so do you by any change have any
>> links that tells about how to install/configure it?
> Oracle Provider for OLE DB
> http://www.oracle.com/technology/tech/windows/ole_db/index.html
> David
>
Thanks David - I'll give it a try.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
Does anybody know if there is a problem/issue with retrieving data from
Oracle on a SQL2005 Cluster? My problem is that I don't seems to have
the MSDAORA provider like I have on my other servers.
I don't recall having ever seen this not being present in a SQL
installation, so I'm wondering if this has something to do with the fact
that it's a Cluster install?
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote in
message news:uAWzvoJYHHA.4232@.TK2MSFTNGP05.phx.gbl...
> Hi
> Does anybody know if there is a problem/issue with retrieving data from
> Oracle on a SQL2005 Cluster? My problem is that I don't seems to have the
> MSDAORA provider like I have on my other servers.
> I don't recall having ever seen this not being present in a SQL
> installation, so I'm wondering if this has something to do with the fact
> that it's a Cluster install?
>
There is no 64bit version of the MSDAORA provider. You will need the OleDB
Provider from Oracle. Get version 10.2.0.2.
David|||David Browne wrote:
>
> ""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote
> in message news:uAWzvoJYHHA.4232@.TK2MSFTNGP05.phx.gbl...
>> Hi
>> Does anybody know if there is a problem/issue with retrieving data
>> from Oracle on a SQL2005 Cluster? My problem is that I don't seems to
>> have the MSDAORA provider like I have on my other servers.
>> I don't recall having ever seen this not being present in a SQL
>> installation, so I'm wondering if this has something to do with the
>> fact that it's a Cluster install?
> There is no 64bit version of the MSDAORA provider. You will need the
> OleDB Provider from Oracle. Get version 10.2.0.2.
> David
Hi David,
Thanks for the info. I'll try to get it working with the Oracle OLEDB
provider. I've never used that one, so do you by any change have any
links that tells about how to install/configure it?
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote in
message news:e1CkGmMYHHA.4232@.TK2MSFTNGP05.phx.gbl...
> David Browne wrote:
>>
>> ""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote
>> in message news:uAWzvoJYHHA.4232@.TK2MSFTNGP05.phx.gbl...
>> Hi
>> Does anybody know if there is a problem/issue with retrieving data from
>> Oracle on a SQL2005 Cluster? My problem is that I don't seems to have
>> the MSDAORA provider like I have on my other servers.
>> I don't recall having ever seen this not being present in a SQL
>> installation, so I'm wondering if this has something to do with the fact
>> that it's a Cluster install?
>>
>> There is no 64bit version of the MSDAORA provider. You will need the
>> OleDB Provider from Oracle. Get version 10.2.0.2.
>> David
> Hi David,
> Thanks for the info. I'll try to get it working with the Oracle OLEDB
> provider. I've never used that one, so do you by any change have any links
> that tells about how to install/configure it?
>
Oracle Provider for OLE DB
http://www.oracle.com/technology/tech/windows/ole_db/index.html
David|||David Browne wrote:
>
> ""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote
> in message news:e1CkGmMYHHA.4232@.TK2MSFTNGP05.phx.gbl...
>> David Browne wrote:
>>
>> ""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk>
>> wrote in message news:uAWzvoJYHHA.4232@.TK2MSFTNGP05.phx.gbl...
>> Hi
>> Does anybody know if there is a problem/issue with retrieving data
>> from Oracle on a SQL2005 Cluster? My problem is that I don't seems
>> to have the MSDAORA provider like I have on my other servers.
>> I don't recall having ever seen this not being present in a SQL
>> installation, so I'm wondering if this has something to do with the
>> fact that it's a Cluster install?
>>
>> There is no 64bit version of the MSDAORA provider. You will need the
>> OleDB Provider from Oracle. Get version 10.2.0.2.
>> David
>> Hi David,
>> Thanks for the info. I'll try to get it working with the Oracle OLEDB
>> provider. I've never used that one, so do you by any change have any
>> links that tells about how to install/configure it?
> Oracle Provider for OLE DB
> http://www.oracle.com/technology/tech/windows/ole_db/index.html
> David
>
Thanks David - I'll give it a try.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
Oracle connection from a SQL2005 Ent. Edt. X64 cluster
Hi
Does anybody know if there is a problem/issue with retrieving data from
Oracle on a SQL2005 Cluster? My problem is that I don't seems to have
the MSDAORA provider like I have on my other servers.
I don't recall having ever seen this not being present in a SQL
installation, so I'm wondering if this has something to do with the fact
that it's a Cluster install?
Regards
Steen Schlter Persson
Database Administrator / System Administrator""Steen Schlter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote in
message news:uAWzvoJYHHA.4232@.TK2MSFTNGP05.phx.gbl...
> Hi
> Does anybody know if there is a problem/issue with retrieving data from
> Oracle on a SQL2005 Cluster? My problem is that I don't seems to have the
> MSDAORA provider like I have on my other servers.
> I don't recall having ever seen this not being present in a SQL
> installation, so I'm wondering if this has something to do with the fact
> that it's a Cluster install?
>
There is no 64bit version of the MSDAORA provider. You will need the OleDB
Provider from Oracle. Get version 10.2.0.2.
David|||David Browne wrote:
>
> ""Steen Schlter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote
> in message news:uAWzvoJYHHA.4232@.TK2MSFTNGP05.phx.gbl...
> There is no 64bit version of the MSDAORA provider. You will need the
> OleDB Provider from Oracle. Get version 10.2.0.2.
> David
Hi David,
Thanks for the info. I'll try to get it working with the Oracle OLEDB
provider. I've never used that one, so do you by any change have any
links that tells about how to install/configure it?
Regards
Steen Schlter Persson
Database Administrator / System Administrator|||""Steen Schlter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote in
message news:e1CkGmMYHHA.4232@.TK2MSFTNGP05.phx.gbl...
> David Browne wrote:
> Hi David,
> Thanks for the info. I'll try to get it working with the Oracle OLEDB
> provider. I've never used that one, so do you by any change have any links
> that tells about how to install/configure it?
>
Oracle Provider for OLE DB
http://www.oracle.com/technology/te...e_db/index.html
David|||David Browne wrote:
>
> ""Steen Schlter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote
> in message news:e1CkGmMYHHA.4232@.TK2MSFTNGP05.phx.gbl...
> Oracle Provider for OLE DB
> http://www.oracle.com/technology/te...e_db/index.html
> David
>
Thanks David - I'll give it a try.
--
Regards
Steen Schlter Persson
Database Administrator / System Administrator
Does anybody know if there is a problem/issue with retrieving data from
Oracle on a SQL2005 Cluster? My problem is that I don't seems to have
the MSDAORA provider like I have on my other servers.
I don't recall having ever seen this not being present in a SQL
installation, so I'm wondering if this has something to do with the fact
that it's a Cluster install?
Regards
Steen Schlter Persson
Database Administrator / System Administrator""Steen Schlter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote in
message news:uAWzvoJYHHA.4232@.TK2MSFTNGP05.phx.gbl...
> Hi
> Does anybody know if there is a problem/issue with retrieving data from
> Oracle on a SQL2005 Cluster? My problem is that I don't seems to have the
> MSDAORA provider like I have on my other servers.
> I don't recall having ever seen this not being present in a SQL
> installation, so I'm wondering if this has something to do with the fact
> that it's a Cluster install?
>
There is no 64bit version of the MSDAORA provider. You will need the OleDB
Provider from Oracle. Get version 10.2.0.2.
David|||David Browne wrote:
>
> ""Steen Schlter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote
> in message news:uAWzvoJYHHA.4232@.TK2MSFTNGP05.phx.gbl...
> There is no 64bit version of the MSDAORA provider. You will need the
> OleDB Provider from Oracle. Get version 10.2.0.2.
> David
Hi David,
Thanks for the info. I'll try to get it working with the Oracle OLEDB
provider. I've never used that one, so do you by any change have any
links that tells about how to install/configure it?
Regards
Steen Schlter Persson
Database Administrator / System Administrator|||""Steen Schlter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote in
message news:e1CkGmMYHHA.4232@.TK2MSFTNGP05.phx.gbl...
> David Browne wrote:
> Hi David,
> Thanks for the info. I'll try to get it working with the Oracle OLEDB
> provider. I've never used that one, so do you by any change have any links
> that tells about how to install/configure it?
>
Oracle Provider for OLE DB
http://www.oracle.com/technology/te...e_db/index.html
David|||David Browne wrote:
>
> ""Steen Schlter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote
> in message news:e1CkGmMYHHA.4232@.TK2MSFTNGP05.phx.gbl...
> Oracle Provider for OLE DB
> http://www.oracle.com/technology/te...e_db/index.html
> David
>
Thanks David - I'll give it a try.
--
Regards
Steen Schlter Persson
Database Administrator / System Administrator
Subscribe to:
Posts (Atom)