![]() ![]() ![]() More than likely, your setup is going to consist of an installation of Oracle and SQL Server on the same computer/PC/notebook. Now that everything is up and running in MSSQL-land, you’re ready to “ Create a Publication from an Oracle Database.”īefore going on with the steps provided by Microsoft, it is worthwhile to create a linked server (a database link in Oracle terms) to the Oracle database of interest. The end result should have the results as seen in the screenshot below. The installation process for Developer Edition (as it is for all 2008 versions) involves quite a few more “Next” clicks from the user (person installing), and it does seem to take a bit longer than MSSQL 2005 installations. The good news is that the cost is fairly low, and with a little shopping around, you can find it online for less than what Microsoft lists it ($49.95 there versus $40.99 at Amazon). The bottom line is you have to order this edition and have it shipped to you. Developer Edition is not free (it was for a while) and it is not available via download (it was for a while). The simple workaround to this requirement is to use Developer Edition, which is equivalent to Enterprise Edition in almost every way. The specific showstopper is the operating system requirement, which is server class (2003 or 2008) across the board. One obstacle, which may be insurmountable (if doing this on a personal computer), is meeting the system requirements for the Enterprise Edition of MSSQL. ![]() One major plus of Oracle over Microsoft is that Oracle software has no expiration date, whereas the trial software from Microsoft has a shelf-life of 180 days. As mentioned in Part 1, one of the requirements on the MSSQL side is that the version be of the Enterprise or Developer editions. In this article, we’ll continue on with the setup of Oracle as a data source for SQL Server. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |