Replication and the FILESTREAM data type

[Kazooie]

Hi, with the DiscountASP.net base hosting plan and the MS SQL 2008 add-on:
- is it possible to use the FILESTREAM data type?
- is it possible to set up a Replication Publisher?
- is it possible to include FILESTREAM data in the replication publications?

Thanks for any information on this subject.

[wisemx]

Hi,
Filestream is not supported:
http://community.discountasp.net/default.aspx?f=16&m=27642

As for replication, you could set that up remotely.
Salute,
Mark



Technical Evangelist for DiscountASP.NET
http://www.iis7test.com/webcasts/
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx

(Microsoft IT Usability http://msitusability.multiply.com/)

[CoastalData]

Hello,

I know this is a slightly old thread, but i was hoping you could clarify something for me...


As for replication, you could set that up remotely.
Salute,
Mark


As far as I've seen, replication is not supported anywhere on DASP... does this change for SQL 2008?

TIA,

--J

[wisemx]

Hi,
The SQL Server 2008 replication works with the new Microsoft Sync network.
What I meant by "local" is using the Sync network on local machines once you pull/pump data from your DASP remote SQL Server. That would work locally for remote "shared" hosting SQL Servers.

Keep in mind this is intended by Microsoft for "high thoughput".
More info here: http://msdn.microsoft.com/en-us/library/ms151198.aspx
All the best,
Mark

[CoastalData]

Hi,
The SQL Server 2008 replication works with the new Microsoft Sync network.


Did you mean to say Microsoft Sync Framework?

Thank you for the info, though, I have a big task of trying to keep certain lists sync'd between the LAN database and the website; it's always one-way, but sometimes I'm pushing to the website, and sometimes I'm pulling from it.

Hmm, well, maybe that's not always exactly true, but in the cases where I'd be updating a list that I ordinarily only pull from, for example, I'd only be updating one record at a time.

Thanks again,

--J

[wisemx]

Hi,
Yes I did mean the Microsoft Sync Framework. ;-)
http://msdn.microsoft.com/en-us/library/cc281959.aspx
I've been testing it on 2 Vista machines and amazingly it is lighter than Outlook on system resources.
All the best,
Mark

[CoastalData]

Cool! How about a webcast on that? :)

[wisemx]

...I'll try ;-)
Locally I'm only running SQL Server 2008 Developer Edition right now on the Webcasts Vista machine, nothing on the second Vista box...but the Sync Framework is on both.

[CoastalData]

"Only" Developer edition? Problem with Sync on Developer Edition? Doesn't that usually have most all of the bells and whistles? I'm running the same version, and haven't had time to explore it much yet.

[wisemx]

Hi,
The Developer Edition does have all the bells and whistles of the full Enterprise version, which is good and bad.
There are some rumors of future versions of SQL Server at the Developer level having a "switch" you can throw to simulate the other versions, which would make it easier to test with and lower on system resources. Makes perfect sense...

On my other Vista machine I was running SQL Server 2005 Developer but could shoot myself for the beta Msft software I tested on that same machine, I had the Business objects tied into SQL Server 2005 and a local pump going both ways, but then the .NET 4 beta took a bite out of everything, kept getting that nasty mscoreei.dll error...Yes I should be using VM for some of that. ;-)
All the best,
Mark

[gabics]

Hi guys,

I am trying to set up a replication between my DASP SQL2008 db and a local SQLCE db. However when I am calling my WCF service I get the :
"Could not load file or assembly 'Microsoft.Synchronization, Version=2.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified." Error.

Seems like the Sync Framework Components are not installed on the server. How do I get them activated/installed? I looked at my DASP control panel but found nothing about Sync Framework. Searching the entire DASP.Net site only returned this post.

Anyone using sync framework on DiscountASP successfully?

Thanks a lot.

[wisemx]

Hi,
We do not have access to Sync, needs to be performed/tested locally.
Everything I referred to previously was for local tests.
To use any DASP data it would need to be Imported using a Task.
Note: I am no longer running any Vista systems.
Sorry for any confusion.
All the best,
Mark