Replication Between Different Versions Of SQL Server

Jul 20, 2005

Hello,

We are trying to set up replication between different versions of SQL
Server (7 & 2000).

This is how the 2 servers are now setup:
DB1 - External web-server w/SQL Server 7
DB2 - Internal server w/SQL Server 2000

REPLICATION SETUP
This is how we need the replication to be set up. They are all
Transactional Replications.

DISTRIBUTION:
This is set up on DB2, which is running on 2000

WITH PUBLISHERS ON DB1, AND PULL SUBSCRIPTIONS ON DB2:
dbo.Employment_App & dbo.Employ_Jobs (together in one replication)
dbo.Feedback
NOTE: This set of replications work some of the time, but make DB1 &
DB2 very slow when running. A lot of times, the jobs say "Retrying
Job", but they usually will eventually work.

WITH PUBLISHERS AND PUSH SUBSCRIPTIONS ON DB2:
dbo.Jobs
dbo.Releases
dbo.Search
NOTE: This set of replications used to work when DB1 & DB2 both ran on
SQL Server 7 with 2000 Enterprise Manager's. But since we moved the
data to an internal server (DB2) that runs on 2000, it doesn't work at
all.

We've researched the problem, and found an article by MS called
"Replication Between Different Versions of SQL Server" at
http://msdn.microsoft.com/library/d...plimpl_4joy.asp
that states that this setup should be possible (on Combination 3 for
Transactional Replications).

But it's not working at all. Are there some steps that we need to
check to have replication setup between 2 servers running on different
versions of SQL Server (7 & 2000)? Any & all help & advice is
appreciated. Thanks.

KWilliams

View 1 Replies


ADVERTISEMENT

Using Multiple Versions Of SQL Server In A Replication Topology

Nov 24, 2006

Hi there,

I have one publicacion on ms sql 2005 Enterprise w.sp1/MS Windows 2003 Enterprise w.sp2 and one subscriber on MS sql 2005 Enterprise w.sp1/MS Windows 2003 w.sp2, but I have also 3 subscriber on MS SQL 2000 w.sp3/MS Windows 2000 advanced server w.sp4. They replicate the same database with a publication compatible with 80RTM, All works fine with data replication, but I can't replicate DDL to MS sql 2005 suscriber, I don't care that don't replicate DDL, but I want manually alter triggers at MS sql 2005 suscriber, but I get this error at the subscriber on when I run the ALTER TRIGGER statement :

Msg 21531, Level 16, State 1, Procedure sp_MSmerge_altertrigger, Line 67

The DDL statement cannot be performed at the Subscriber or Republisher.

Msg 21530, Level 16, State 1, Procedure sp_MSmerge_ddldispatcher, Line 181

The DDL operation failed inside merge DDL replication manipulation.

Msg 3609, Level 16, State 2, Procedure TU_Centros_Distribucion_Articulos, Line 58

The transaction ended in the trigger. The batch has been aborted.



Any help will be appreciated,



PD. I miss sql2000 replication, where I have full control over the database logic

View 14 Replies View Related

SQL Server Admin 2014 :: Transactional Replication With Different Versions

May 17, 2015

We have installed 2014 sql server. We have currently 2008r2. We have to run the real time report. So we need to set up transactional replication b/n those two servers. We need to use 2008r2 as publisher and 2014 as subscriber.

Is it ok to have subscriber higher version than the publisher?

View 6 Replies View Related

Different Versions Of MS SQL Server

Sep 23, 2005

Hi all...
I'm a MySQL user and I want to switch to MS SQL Server, I heared that there is more than one type of MS SQL Server and one or two can be downloaded for free. Can someone tell me the different types of MS SQL Server and where can I download those free versions?

View 5 Replies View Related

Different Versions Of SQL On One Server

Sep 25, 2007

Hi,

Our server has SQL Server 2003 installed, I'd like to use SQL Server Express 2005 as I'm about to try and learn ASP.NET and most tutorials use that.

Will installing Express 2005 conflict with the Server 2003? Can both version be run on one server?

Thanks.

View 3 Replies View Related

Two Versions Of Sql On One Server?

Oct 25, 2006

Is it possible to run both SQL200 standard and SQL2005 Express on thesame server? I need to test a database created in 2005 on ourproduction server but don't want to upgrade our "live" databases yet.

View 2 Replies View Related

SQL Server - Differente Versions

Jan 28, 2008

Hi
If i develop a web application with sql server developement edition, it works fine in my webserver, or my webserver has to have the sql server development too?
I'm interested in sql server report services. if i develop a web application with this tool what kind of version of sql server has to be installed in my webserver?
Thank you

View 2 Replies View Related

MS SQL Server Vs. Run Time Versions Of Other DBs

May 13, 2002

I know this is a very basic question for all of you but I need help.

I am a CPA working with a client to select an accounting & project management software for a construction client. In the top 5 choices, there are 2 that require MS SQL Server as the DB. This client will have about 10-20 users, including project managers & accounting personnel but by DB standards transaction volumes will be low. The company has a few large projects. There is no inhouse IT staff; network administration is outsourced.

The question on the table is this? How much more difficult is it to use MS SQL server in this environment? If all of the client's requirements can be met using a run-time version of Sybase, Pervasive, or FoxPro, isn't this the simplest solution. I don't want to recommend an elephant if it is not needed. I would appreciate your opinion....Thanks

View 2 Replies View Related

Differences Between SQL Server Versions

Jul 20, 2005

Hello,I've got installed Win 2003 SBS Premium with the SQL Server 2000 on a servermachine. It works almost fine, except the application which uses the SQLServer. The main part of the application runs (since the last update) fine,but other tools of that application (database import and the databasemanager for check and rebuild) doesn't. They hang up or kill the database.Our software developer says that these problems are in correlation with theserver os. But there won't be any problem if we install Win 2000 Server andadd an additional SQL Server 2000.Finally my question is: Are there any differences between the SQL Server2000 Versions, which are sold (a) as a single product, (b) as part of theWin 2003 SBS Premium package and (c) as part of other Server versions?Thanks in Advance,Martin

View 6 Replies View Related

Difference Between The Versions Of SQL Server

Jun 22, 2006

Do you find that there is a big difference between the different
versions of SQL server (6.5, 7, 2000, 2005) as is between Microsoft
programming languages (VB.4, VB5, VB6, .Net and now .Net 2)
Or is the difference in SQL server minimal and very small compared to the programming languages I mentioned.
Thanks a lot

View 3 Replies View Related

SQL Server 200 Developer Vs Enterprise Versions

Aug 11, 2006

I am having some problems in the process of moving an Access back-endto an SQL Server back-end. Everything works but there are severeproblems of response times when the number of users builds up.At present we are using the Developer version before committing to theEnterprise version. BOL (quoted below) seems to suggest that, apartfrom licensing, they are the same.Can anyone please confirm that this is so. If not, what is thedifference?I may explain in another topic the problems I am facing but I firstwish to be clear on this particular question.---------------------------------------------------------------------------------------------------------------Quote from BOLMicrosoft® SQL Server™ 2000 is available in these editions:SQL Server 2000 Enterprise EditionUsed as a production database server. Supports all features availablein SQL Server 2000, and scales to the performance levels required tosupport the largest Web sites and enterprise online transactionprocessing (OLTP) and data warehousing systems.SQL Server 2000 Developer EditionUsed by programmers developing applications that use SQL Server 2000 astheir data store. Although the Developer Edition supports all thefeatures of the Enterprise Edition that allow developers to write andtest applications that can use the features, the Developer Edition islicensed for use only as a development and test system, not aproduction server.

View 5 Replies View Related

Sql Server 2005 Enterprise Versions

Apr 26, 2006

Hi,

I would like to know what are the differences between these versions:







SQL Svr Enterprise Edtn 2005 Win32 English MVL

SQL Svr Enterprise Edtn 2005 Win32 English MVL 1 Processor License

SQL Svr Enterprise Edtn Win32 English Lic/SA Pack MVL

SQL Svr Enterprise Edtn Win32 English Lic/SA Pack MVL 1 Processor License

SQL Svr Enterprise Edtn Win32 English Lic/SA Pack MVL Comp Promo

SQL Svr Enterprise Edtn Win32 English SA MVL

SQL Svr Enterprise Edtn Win32 English SA MVL 1 Processor License

SQL Svr Enterprise Edtn Win32 English SA Step Up MVL

SQL Svr Enterprise Edtn Win32 English SA Step Up MVL 1 Processor License



Regards



Ayzan

View 1 Replies View Related

Both Versions Of SQL Server In A Clustered Environment

Oct 4, 2007



I am looking at combining / consolidating some of our servers and was wondering if I can install SQL 2000 and SQL 2005 in a clustered Environment on a san.
Cheers
Angie

View 6 Replies View Related

OLEDB Interface To Multiple SQL Server Versions?

Mar 4, 2008

Howdy Folks!

I just finished an OLEDB interface written in VS2005 C++ that works with Sql Server Compact Edition 3.1. My team now wants me to make my interface compatible with Sql Server 2000, 2005, and 2005 Express. My question is...what header/lib files do I need installed and in my stdafx.h to pull this off? Is there a particular order I need to include these files in?

Right now I'm just including the following for SSCE:


#include <ssceerr30.h>

#include <ssceoledb30.h>


Once I get the right includes figured out, the next step is figuring out what CLSID's I should use in the CoCreateInstance call. I *think* I'm supposed to use CLSID_SQLOLEDB for 2000, CLSID_SQLNCLI for 2005, and I haven't a clue for 2005 Express. I could use some clarification on this as well.

Thanks a ton in advance...I've always been impressed by the MSDN boards...

View 6 Replies View Related

Features Not Supported In Future SQL Server Versions

Nov 29, 2007

Books online "Deprecated Database Engine Features in SQL Server 2005" makes references to "Features not supported in Future SQL Server versions".

http://msdn2.microsoft.com/en-us/library/ms143729.aspx

Will there be an Upgrade Advisor available to help us identify issues with our code any time soon or should we start building our own?

View 3 Replies View Related

Multiple SQL Server Native Client Versions

Nov 24, 2006

One of the big problems with the old MDAC was different versions on different client machines. You would test your app with the latest version say, but when you deployed it, it might fail as the client has a different version.

My company develops software for Municipal Government clients. These clients use other SQL Server applications as well as ours, but they can only use one version of the client software (MDAC) on a given desktop. That means if we require a particular MDAC version, but the clients other applications from other vendors don't officially support that MDAC version, the client is in a real jam.

Our software also supports Oracle, which allows our software to specify a particular Oracle Home which points to a directory with a particular version of the Oracle client dlls (along with corresponding registry entries for that Oracle Home), such that we control the exact client version of the Oracle software that the client uses with our applications. This will not interfere with, and is completely seperate, from the default Oracle home installed when you install the Oracle client software.

What I would like to see for the Native Client is the ability to have our applications use the version of the Native Client that we wish to support and deploy without interfering with the Native Client version used by other applications. Have a default Native Client, but allow applications to somehow specify a different Native Client version/set of DLLs.

Is there any such functionality with the Native Client? (I didn't see any mention of such in the documentation, but I thought I'd ask)

If not, are there any future plans to support multiple Native Client versions on the same desktop?

View 1 Replies View Related

SQL Server Compact/Mobile Edition Versions

Mar 12, 2007

I am confused about the version numbers for SQL Server Compact/Mobile. It _looks_ like the versions went from CE 2.0 to Mobile 2005 to CE 3.0 (or 3.1). Is this correct? In fact, I found one location the specifically said Compact Edition is the next version of Mobile. In another location I saw Compact Edition referred to as 2005 CE.

This has got me going because I am creating a Mobile/CE app and I keep getting a "Initialize SQL Server Reconciler" and the best information I can find indicates a mismatch between the server component and the client component.

So, what are the current versions of Mobile/CE? Is there a location that lists all of the components and what version they should be?

Thanks.

Chris Mecum

View 5 Replies View Related

Multiple Versions Of SQL Server 2005 - What Order To Install?

Jun 15, 2007

I currently have three SQL Server instances installed on my notebook. One is v8, which I believe is used by an accounting application. The other two are as follows:-

SQL Server MSSMLBIZ

SQL Server SQLEXPRESS



The second one (SQLEXPRESS) fails to start generating the following error:-

The SQL Server (SQLEXPRESS) service terminated with service-specific error 17058 (0x42A2).



Other services listed in SQL Server Configuration Manager are:-

SQL Server Integration Services - which runs apparently normally.

SQL Server Analysis Services (MSSQLSERVER)

SQL Server Reporting Services (MSSQLSERVER)

SQL Server Browser



The last thre of these are run under LocalSystem.



I have been trying to install the SQLServer SP2 to the SQLEXPRESS instance for some number of days now, but each time it runs, it fails to install.



I am beginning to wonder if there is a sequence of installation for each of the above instances that should be followed. Can anyone give me any suggestions, or answers to the above problems?



Thanks,

View 3 Replies View Related

Installing SQL Server Express And Full Versions On The Same Machine

Jun 14, 2007

Simple question, is it doable?

I tried once before and my machine was messed up.

Thanks

View 3 Replies View Related

Versions Of Windows Allowed For SQL Server 2005 Developer Edition

Jul 8, 2007

Hi, I am going to get a new laptop and was wondering in particular which versions of Windows Vista will run SQL Server 2005 Developer Edition. I want to be able to use all the features of SQL Server 2005, so IIS is needed for example ( I will be building end to end BI soutions using SQL Server Management Studio, SSIS, Analysis Services and Reporting Services.


Chris

View 13 Replies View Related

Visual Studio 2005 Shows Wrong SQL Server Versions

Apr 2, 2007

Visual Studio 2005 shows SQL Server 2005 installed product versions differently than the actual. As seen below VS2005 displays 9.00.3042.00 as the version of SQL Server 2005 however it is 9.00.3050.00 in SQL Server Management Studio. [Look at Installed Products section after selecting About MS Visual Studio from Help menu ]



SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 9.00.3042.00

SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 9.00.3042.00

SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 9.00.3042.00



I have VS2005 SP1 and SQL2005 SP2 installed. Why VS2005 reports versions wrong?

View 1 Replies View Related

SQL Server 2012 :: Retrieving Dataset That Only Includes Latest Versions Of Data

Mar 28, 2014

In our Microsoft Dynamics Nav instance we have a Sales Header Archive table - into which copies of the Sales Header are placed, with 3 items forming the compound key:

Document Number
Version
Occurrence number

so if doc 1 is archived, then the records would be

Doc# | Version | Occurrence #
1 | 1 | 1

When a second copy is archived a new record is added:

Doc# | Version | Occurrence #
1 | 1 | 1
1 | 1 | 2

and then when maybe a 3rd version is archived a 3rd entry added

Doc# | Version | Occurrence #
1 | 1 | 1
1 | 1 | 2
1 | 2 | 2

This is for EACH document and I now need to retrieve the dataset which is the latest version of each document... but I'm drawing a blank!

If I

select [Doc#], max([Version]) as [V], max([Occurrence #]) from (table) group by [Doc#]

then I get the distinct list of docs, but I now need to use this list to select the records which match this criteria, from this table.

How do I select just these?

I thought (wrongly) that I could simply say:

Select * from Invoice Table where
Invoice.[Doc#], Invoice.[V], Invoice.[Occurrence #] in
(select [Doc#], max([Version]) as [V], max([Occurrence #]) from (table) group by [Doc#])

View 2 Replies View Related

Help With Versions

Apr 24, 2001

We are in need of a solution to our problem. We are working for a customer and cannot use their database to work on during development. We have copied the layout and made a sample db for our development.
Rather than writing down all the changes we make to our own db and then making the same changes to the customer's, is there a better way? Can we use something like sourcesafe?
Thankyou

View 1 Replies View Related

SQL Versions

Oct 20, 2004

I've got a few SQL Servers at work which are development servers using SQL Server Standard Edition. I would like to downgrade them to SQL Server Developer Edition to save the Standard Edition licenses for production purposes. However, i do not wish to uninstall and reinstall SQL Server Developer Edition, restore all the dbs. Is there a way to change the version of the SQL Server ?

View 2 Replies View Related

Two Versions On The Same Box

Oct 9, 2007



Hi All,
Can we have 2 versions of SQL Server on the same server? Example, can I install SQL Server 2000 and 2005 on the same server? Please let me know about all the combinations possible/not possible.

Thanks a lot.

Mannu.

View 3 Replies View Related

Updating Need Two Different Versions

Dec 21, 2005

Is there a way to do the following -- I need to be able to update a table based on a selection by a DDL.  So here are my two update queries:
1. Update RequestData Set Approved = True Where DeptID = @DeptID2. Update RequestData Set Approved = True (Yes I need to be able to do all of the rows at once.)
But it's all based on the selection of the DDL---I really don't want to have to create two seperate sql commands any ideas?

View 4 Replies View Related

DTS Package Versions

Mar 22, 2001

Is there a way to remove old versions of a DTS package without rewriting the entire package?
These packages run fine but take up more space than I am willing to allocate.

View 1 Replies View Related

Versions Of SQL For SAN Support

Oct 22, 2001

I understand the SANs are only Supported by SQL Server 2000 Enterprise and no other versions of SQL, can anyone supply information to the contrary please?

View 2 Replies View Related

Multiple Versions

May 12, 2000

Has anyone ever attempted to run 6.5 & 7.0 from the same server?

View 1 Replies View Related

Installing 2 Versions

Mar 4, 1999

This may seem like a wierd question, but can I have 6.5 and 7.0 running on the same machine? I need 6.5 for production builds and 7.0 for test. Is this possible? THanks

Frank

View 1 Replies View Related

Trial Versions Of 7 Still Available?

Nov 15, 2001

I can see that SQL server 2000 trial is available for download, but I need to try out 7 for a particular project at work. Is this available for trial download? (Has it ever been?)

Thanks.

View 2 Replies View Related

Synchronized Versions

Jul 23, 2005

I'm running a SQL 7 db on a LAN in city A with other users accessing it fromanother city (city B) over a WAN. Obviously the WAN users are getting muchslower access to the data. One thing I was wondering was if it was possibleto have two versions of the database, one on each server, and have themautomatically synchronize as users at each location make changes. Or, ifthat's not possible, then at least have the city B users get any changesthat the city A users get as they are made.Thanks for any input.Neil

View 5 Replies View Related

32-64 Bit Versions Issue

Jan 23, 2006

I uninstalled the 32-bit Standard version but during install of the 64-bit trial version I got an error that the integration services could not install because the 32-bit version of COM+ was already registered and you can't have both. Need some help how to resolve this issue. Thanks

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved