What SQL Server for Windows XP?

[i3bex]

I want an SQL server for Windows XP that has a capacity of merge replication with an SQL Server 2000. Would MSDE work? Are there any objects in the .NET Framework built for Merge replication?

I basically want the functionality that exists between the .NET compact framework (System.Data.SqlServerCE namespace), SQL Server 2000, and SQL Server CE.

I've been programming on the .NET Compact Framework for about a month and now we have a change of plan.

Peace

PS: I have been reading for 2 days trying to figure this out.

[i3bex]

It is funny how you find the answer after you ask somebody.

<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp>

Now all I have to find out is if .NET Framework supports replication programmatically.

If you have the answer, please ...

Peace

[techgnome]

In short: No.

In longer words: Mainly because there is no .NET equivelent to the SQLDMO Replication objects. They are still in COM format (subject to change when the SQL 2005 comes out).

Which means that you could do it in .NET ala interop wrapers, but it is very tricky and not all of the objects lend themselves to .NET very well.

-tg

[RobDog888]

Did you read my PM message I sent you a few days ago pieceofcrap2001?

[i3bex]

Thanks techgnome. You've led me to the write direction.

Unfortunately, we decided not to go through the projcet.

I've worked here a month and 15 days so far. My boss has given me 4 projects and has canceled 4 projects. That I means my work for the last a month and a half has been nothing.

There are two ways to do what I wanted to do:
1) Replication ActiveX controls
2) Managing replication by using SQL-DMO replication objects

http://support.microsoft.com/default...;en-us;Q324992

[techgnome]

If you have to, use SQLDMO.... you'll have greater control. If at all possible, avoid using Replication all together. It's a house of cards technology and can go very wrong very fast.

-tg

[i3bex]

techgnome:

Thanks again. we are not going through the project any more. We are going to start e-mailing changes to oursales people so they can import changes from a text file instead.

i3bex (changed name)