I have 4 SQL express servers in 2 networks (2 SQL's in each network).
How can I sync them?
Can I only sync each pair?
I may be short of details here... what else need to know?
Any info/help will be great.
View Complete Post
I have create a subscription (pull, merge replication) on SQL Server 2008 R2 Express Edition to a publication on SQL Server 2008 R2 Enterprise Edition. I have seen that the subscription has been enabled for Windows Sychronization Manager as I can see in
its property dialog. However, I cannot see it in the Sync Center of Windows 7 on the Subscriber.
Does Sync Center support in this scenario? From
another thread, it seems we need to use Windows Task Manager. If so, how can I set it up?
Thanks in advance.
I am not able to configure the system in order to make it solve merge conflicts
interactively (that is with the help of the user).
The configuration is the following one:
PC-A: sql server 2008. With one the DB "myDB" published for replication.
PC-B: sql server 2008 r2 express. With two replicas of "myDB" on the same instance of sql express: "myDB1Replica" and "myDB2Replica"
The two replicas simulate two users that change the content of the same record so that I can test how the system behaves in case of conflicts.
Everything runs smoothly if "Resolve conflicts automatically" is set... but I get this error message when "Resolve conflicts interactively (only applies to articles that support interactive resolution)" is selected.
Error: The merge process failed to get correct information about the Interactive Resolver component from the registry. Verify that the registry exists and that the path is correct.
Of course this has been enabled on the article (from PC-A on sql server) and on the subscription (from both PC-B sql express and syncro center) as well.
I have been searching everywhere and found nothing! Any help would be really appreciated! I really need to run the interactive conflict resolution
I am trying to figure out how I can sync a client machine running Windows XP or Windows 7 and running SQL Express 2008 R2. I want to try and initiate a pull from the client to the publisher (Merge Replication). I am having an issue trying to
figure out how I can use the windows sync manager to accomplish this since the client doesn't have SQL Agent to actually run the sync job.
Is there another way to kick off the pull from the publisher? I had originally wanted to push everything down from a server (publisher), but because of our strict firewall policy, etc I can't seem to establish a remote connection to the clients.
Any information or suggestions would be greatly appreciated.
I am running SQL Server 2008 Express R2 64-bit on Windows 7 x64, and I've created a subscription to a database publication on a Windows Server 2008 with SQL Server 2008 R2 standard. The subscription created fine on the Windows 7 machine in SQL Server Management,
but it does not display in the Sync Center. I have set the subscription to "Use Windows Synchronization Manager" and recreated the subscription several times, but it never shows up.
I've searched for hours and I cannot find any answers to this. Has anyone else run into this problem? Is there a step I'm missing?
I created a site and am trying to grant another pesron access to upload
changes to it without giving them my super-user login.
I made a login for her but I can't test whether it works or not because no
matter how much I "disconnect" in the Copy Web Site page of VWD 2010, reconnecting to the same site always logs in as
my superuser account without prompting me for a login again.
How do I test is the account it set up correctly before having her try to
upload to it? I want to force the login to remote site dialog to pop up
again to test her account.
I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.
I have two SQL Server instances installed.
1- UserLT (this is sql 2000)2- UserLT\SQL2005 (this is SQL 2005 named instance)
But when i try to add a database to my VS website project I get the following error:
Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925
I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)
and changed the "SQLEXPRESS" to "USERLT\SQL2005".
But I still get the same error message. Any ideas how i can resolve this issue?
The Sync Framework can be used to build apps that synchronize data from any data store using any protocol over a network. We'll show you how it works and get you started building a custom sync provider.
MSDN Magazine August 2010
Video on the Web involves huge amounts of data. Learn the best way to manage and move that data with the help of Microsoft Expression Encoder 3.
MSDN Magazine June 2010
Synchronization Services for ADO.NET provide a set of tools to help you synchronize data between two database sources, synchronize files between machines, and synchronize with an RSS or ATOM feed. Learn more here.
MSDN Magazine April 2009
Charles Cox and Michael Klucher
MSDN Magazine May 2007
The Express Editions of Visual Basic and SQL Server 2005 have lots of the features of the full-sized versions, but with a lot less of the overhead. Professional developer features such as full IntelliSense support, local debugger, Add Web Reference, and the improved Visual Data Tools will all be available in the Express products, so you don't have to leave your favorite features behind. In this article the author introduces you to these express editions and builds a sample app to get you started.
Brian A. Randell
MSDN Magazine September 2004
just a quick question, are there a lot of developers using the express edition to make web sites, or is it limited to what you can do, and I would be better getting the full edition visual studio 2010. I have been using dreamweaver, but I wanted to try my hand at asp.net, thx for any info you can offer.
Hi,I have installed Visual Studio 2010 Express in my local system. Steps1. File->New Website2.Open datbase explorer, right click on dataconnection3.Select Create new connection4.use Microsoft SQL Server Database file5. Type new databse filename6. Now i want to use SQL authentication which is not working7.If we use windows authentication its wokring without any problem8.But i need sql authentication to be used.9.I have not installed SQL studio. I am only using the one which is packaged in VisualStudio 2010 SQLClient.Let me know how can we create a new database file with userID and password. So that i can host it in other systems as well without any windows authentication.Thanks and regardsMahesh kotekarhttp://mahesh.kotekar.com
Hi, I have installed Visual Studio 2010 Express in my local system.
Steps 1. File->New Website
2.Open datbase explorer, right click on dataconnection
3.Select Create new connection
4.use Microsoft SQL Server Database file
5. Type new databse filename
6. Now i want to use SQL authentication which is not working
7.If we use windows authentication its wokring without any problem
8.But i need sql authentication to be used.
9.I have not installed SQL studio.
I am only using the one which is packaged in VisualStudio 2010 SQLClient. Let me know how can we create a new database file with userID and password. So that i can host it in other systems as well without any windows authentication. I know that VS2010 setup also installs the SQL client which is requiredto create and manage sql databse files/quries etc
i dont know the default userID and password for SQLauthentication. As the express setup did not asked any credentials while installing SQL components
Thanks and regards
I'm trying to embed a flv in my web page and I don't have a clue how to do it.
I downloded and installed ASPNetFlashVideo and the tools do not appear in my toolbox.
So if anyone has a work around it would be greatly appreciated.
I have several css style sheets I want to work with. I have copied them into the appropriate directory structure in my project. The styles are applied correctly.
But the manage CSS styles tool bar on the left margin doesn't seem to work correctly. At one point I had generated a style sheet and worked with it there, but now it not only can't find the one it generated, but the attach style sheet link doesn't respond at all, nor does anything in this bar. Same deadness with the CSS Properties bar. With or without a style sheet loaded in the editor -- a style sheet that is active in the project such that when I run it, the styles are applied.
VB version of studio, running on Vista home basic.
PS, the design mode works a lot better than the professional version I use in my day job on XP and server 2003.