Replication To Web Hosting Service

Jun 6, 2007

Architecture question for anyone....We have a typical SQL Server 3-tier VB.net app running at corporate and want our customers to interact through a website. If we host the website on-site, we can simply access the DB; but if we host at a remote location and want the users to perform updates (think DHL, Wells Fargo, Amazon), we'll need replication with Peer-to-peer. Some basic questions:
1) is everyone doing it this way?
2) will we need a full time replication consultant to set this up, keep it up, and keep an eye on it (administering the 50 user, 200 table DB is relatively easy and we've not needed a DBA for the past 10 years).
3) we're not DHL or Amazon, we just want that kind of end user add/update/delete functionality...so transation rates will be miniscule. But still, the corporate site is constantly being updated so we'll need a fat pipe to the hosting service, etc... any thoughts on performance?
any other tips on doing an installation like this?
thanks in advance
john

View 2 Replies


ADVERTISEMENT

Hosting SQL Everywhere In A Windows Service

Jul 13, 2006

The Sql Mobile site on MSDN recommends that you do not host SQL Everywhere when running as a service. Is this a recommendation, if so why, or is it simply not possible. My understanding is that when hosteed in a IIS hosted application a not supported exception is throw.

If anyone has any ideas on this or pointers to some resources i would appreciate them.

Thank You

View 1 Replies View Related

SQL Express And Selling As A Hosting Service.

Apr 29, 2006

Hi,

Can a web hosting company charge clients for using an SQL Express  instance on their network?

E.g. The host charges the client $x per month per instance. Is this legal?

View 1 Replies View Related

My Hosting Service Requires Csv Upload ONLY!!!!

Oct 20, 2007

Hello,
Im a bit of a novice at this so please bare with me


Does anyone know how to convert a .mdf to .csv as my hosting provider will only allow .csv importing to there SQL servers.

Plus will my data base work in this .csv format. (comma separated value)

Thanks in advance

View 2 Replies View Related

Problem Setting Up SQL DB With Web Hosting Service (IPOWER)

May 6, 2008

I created a small ASP.NET website with VS2008 that employs user authentication (login) functionality to protect some of the site data and allow access only to authenticated users. This functionality created an ASPNETDB SQL database in the project to hold all the user data such as usernames, passwords, user roles, etc. The website works flawlessly on my local PC but when I copy the files to my windows-based web server (IPOWER host) I can't find a way to activate the SQL database so the user authentication functionality works. I've been through all the Scott Guthrie tutorials on this subject here and here, but none of the suggestions worked for me. IPOWER is no help since they will not provide technical support for scripting.

I'm at a loss. This is just a simple little website but I've hit a wall and can't seem to find my way around it. I am new to ASP.NET and SQL server applications so my newbie status certainly plays a role here.

I will gladly pay someone (via PayPal) to spend time with me on the phone talking me through the steps to get the site working on my web hosting site. Other than that, are there any other suggestions on what I could try?

Thanks in advance for your help with this.

Doug

View 6 Replies View Related

SQL 'Server' Or 'Local' Database For Uploading To Hosting Service Provider

Mar 23, 2007

Hi, I'm developing a website using VWD 2005 Express, which needs a Membership system and a products database. Using the VWD inherent Web Site Administration tool makes the membership set up easy but by default it creates a 'Local' SQL database in a folder named 'Apps_Data' in the VWD project. My question is: considering I will need to upload my web site to a Hosting Service, would it be better to change the default so that the membership systems, and the product database I need, are created in an SQL 'Server' database instead of a 'Local' database?
The hosting service I am considering using is having a bit of a problem understanding this question, I hope it makes sense to someone or am I asking a stupid question?
Regards
Sean.

View 2 Replies View Related

How To Import SQL 2005 .BAK From One Hosting Package To A Different Hosting Package?

Nov 3, 2007



I have a SQL .bak generated by our existing hosting package at 1and1.com, I want to import that SQL .bak to our new hosting package at ixwebhosting.com.

ixwebhosting.com don't have a import feature in their control panel.

I have to maintain the SQL at ixwebhosting.com using Microsoft SQL Server Management Studio Express since they don't have that feature in their cp. I don't see any import features in Microsoft SQL Server Management Studio Express either.

How can I import it using Microsoft SQL Server Management Studio Express or another free GUI program?

View 4 Replies View Related

Merge Replication With Different Service Packs

Jan 31, 2006

I have a Win 2003 server with SQL 2000 SP3 that is publisher and distributor for several merge replication publications. Subscribers are a mixture of SQL 2000 (running SP3 and SP4) and MSDE. I've run into a problem in creating publications that is fixed in SP4 but for various reasons I can't update all of the subscribers that are running SP3. I don't expect any issues updating just my server but will I have any issues running SP4 on my server and SP3 on the subscribers?

Thanks for the help.

Gary

View 1 Replies View Related

SQL Replication Vs SQL Service Broker (SSB) For SQL 2005

Aug 17, 2006

Hi

I am presently working on a requirement involving a central SQL store replicating data with 600+ stores.

Presently the no of stores is 300 and it would eventually more than 600+ shortly.

What would be the best option to use in this scenario?

I am told that for more than 600 stores the replications would serioulsy impact the performance and SSB would be more advisable.

Now i am newbie on SSB and would like to know from the experts whether its a correct way of implementation

TIA

Paritosh

View 4 Replies View Related

Replication Fails After Service Pack 1

May 26, 2006

We have two servers using merge replication. I have updated one with SP1 and not the other (yet). Replication fails to work after the upgrade. I get the following error message:
Date 5/26/2006 2:09:08 AM
Log Job History (BB-CM1-SRV1-CountAndCrush-New Sync for Crusher-CC-SQLSRV-6)

Step ID 2
Server BB-CM1-SRV1
Job Name BB-CM1-SRV1-CountAndCrush-New Sync for Crusher-CC-SQLSRV-6
Step Name Run agent.
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
2006-05-26 06:09:08.316 Category:NULL
Source: Merge Replication Provider
Number: -2147199417
Message: The Publisher failed to allocate a new set of identity ranges for the subscription. This can occur when a Publisher or a republishing Subscriber has run out of identity ranges to allocate to its own Subscribers or when an identity column data type does not support an additional identity range allocation. If a republishing Subscriber has run out of identity ranges, synchronize the republishing Subscriber to obtain more identity ranges before restarting the synchronization. If a Publisher runs out of identit
2006-05-26 06:09:08.316 Category:SQLSERVER
Source: BB-CM1-SRV1
Number: 20663
Message: The publisher's identity range allocation entry could not be found in MSmerge_identity_range table.

View 3 Replies View Related

SQL 2012 :: Apply Service Pack When Databases Are In Replication?

Jun 5, 2015

how to apply service pack when the databases are in replication?

View 2 Replies View Related

Dont Service Broker And Replication Serve The Same Purpose When Used To Ship Data?

Dec 17, 2007

when shipping data from one place to another, without complicated merge needs, do service broker and replication differ in what they offer?

View 4 Replies View Related

Help With My Hosting!

Nov 14, 2006

I've hosted a website in a freehosting account which supports .net 2.0 and SqlServer 2005Express and they only gave me an ftp access which i can access my website, i found that there's the "App_Data" folder which i placed my database in.Now here's the message i get when i try to connect to the SQL Express DBAn attempt to attach an auto-named database for file I:DataWebqsh.eucipherasp_015f1bdd-1338-4a35-9873-b29232b472c9wwwApp_Datacipherasp.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC shareSo, what should i do!

View 5 Replies View Related

Web Hosting

May 21, 2008

 Developer made website. I want to upload in sever. There is
no index.html. Linux  server is not
supporting. Files & Folders are the following.

1. ADMIN       2. APP_BROWSERS     3. APP_CODE       4. APP_DATA     5. BIN     6. IMAGES        7. ADS.XML

8. CALENDARDATEINPUT.JS      9. CHKUNCHECK.JS    10. CONTACTUS.ASPX     11. CONTACTUS.ASPX.CS     12. COUNT.JS13. COUNTING CHAR.ASPX       14. COUNTING CHAR.ASPX.CS     15. DEFAULT.ASPX     16. DEFAULT.ASPX.CS

17. DEFAULT.CSS          18. LOGIN.ASPX       19. LOGIN.ASPX.CS     20. MASTERPAGE.MASTER21. MASTERPAGE.MASTER.CS    22. MYCUSTOMPAGE.HTM    23. RECOVERYFORM.ASPX   24. RECOVERYFORM.ASPX.CS

25. REGISTRATION.ASPX      26. REGISTRATION.ASPX.CS       27. SALE.ASPX     28. SALE.ASPX.CS    29. SMS.ASPX30. SMS.ASPX.CS    31. SMS1.ASPX    32. SMS1.ASPX.CS     33. SMSSERVICE.ASPX   34. SMSSERVICE.ASPX.CS

35. TERMSCONDITION.ASPX   36. TERMSCONDITION.ASPX.CS   37. WEB.CONFIG  38. WEB.SITEMAP

39. XMLFILE.XML Please suggest  & support me which server will support my file. I am
waiting your answer. I shall be very grateful to you. My email address is yog2599@sify.com

Thanks.

   

  

View 4 Replies View Related

DTS From Hosting

Nov 28, 2004

I am trying to export from an SQL Server on a hosting company to my own computer using DTS. I'm new to SQL Server manipulations like this so please go easy on me...

I can't seem to manage to do this properly - If I select "Copy tables & data only" it will not copy the identity constraints and primary keys. If I select "copy all objects" it starts giving me permission issues which I cannot seem to resolve, because I guess the tables on the hosting server are owned by my username up there, but when they come to my computer they are orphant?

Isn't there an easy way to do this? It's a very simple database, tables and that's it, not even any stored procedures.

View 3 Replies View Related

Sql Hosting Help

Oct 9, 2006

I told my client to use a particular host, or at least one that offers a database... they instead went with a friend of a friend that offers hosting as a reseller.

Now I'm the web developer for this huge site overhaul which requires a database with a host that doesnt offer it.

I'm new to databases... thats why I'm accustomed to using the simplicity of ipowerweb or mediatemple and their phpmyadmin interface.

Anyway... what do I do? Will a database hosted elsewhere work? If you know about this stuff, please help.. I may not be asking the right questions!

THanks!!!

View 1 Replies View Related

Fst CPR For My Hosting DB

Feb 22, 2008


Hi

I have experience only designing an implementing DB in sql2000 but not too much administering.

My app is a Web Service that communicate with my DB.

The DB is in a hosting company, so I don€™t have too much permissions to play with.

The application have been the same for at least one year, no changes at all but recently my users complaint that the system was not working/responding.

I immediately thought about excessive load

When I went to query analyze and execute the command (sp_who), I saw that 173 processes where sleeping €“ awaiting command

that is the only thing I can imagine was the problem(not sure yet). I investigated and found the Kill process instruction but I was not able to run it because permission.

Based in this scenario How can I give a fast CPR to drain my DB and allow my user to work?
Any link?
Any sug?

thanks

View 6 Replies View Related

SQL Database (One And One Hosting)

Dec 30, 2006

Does anyone use One and One Internet (UK) for their hosting?
I use them and when I published my site all membership feautures wouldn't work, I called the One and One support and they said that their servers only support SQL Databases if they were created using their own tool in their control panels.
How would I get my site to use their database, I'm really not sure.
If anyone else could help me out I'd be grateful.
Kind Regards
Mattie

View 2 Replies View Related

Sql Express HOSTING

Jun 24, 2007

hello guys
 I am developing ASP.NET  applications in order to build a portfolio, im using MS SQL EXPRESS databases, do i need a hosting account that allows multiple sql databses or does SQL express fit in to your application, eg as many as you like in as amany applications. I am asking this because i know MS SQL  server is a different thing from MS SQL EXPRESS server and hosting companies say stuff like 1 MS SQL databse and stuff. I have multiple applications that wont need the real MS SQL databse because there not live just portifolio stuff. 
 Can somone sugest a ASP.NET hosting company please a cheap one.
 Thanks
 Nadeem

View 2 Replies View Related

MsSQL Hosting

Feb 16, 2005

I will like to know the files i will load to a remote server if i want to host an sql database.
let's use the northwind database for example, if i want to host it on hosting server what are the files i will host i mean i need a detailed procedure on how to go about it.

View 1 Replies View Related

MSDE Hosting

Jun 11, 2006

Hi all!
One good thing about access databases is the ability to upload the .mdb file to a hosting server and not being charged for database space.
How about MSDE? Does it require SQLServer hosting or can it be done just by uploading the database file?
Thanks,Ricardo

View 1 Replies View Related

Sql Server 7 And Web Hosting

Oct 29, 1999

How u can connect u sql database with web server ?


bye
Navnit

View 2 Replies View Related

Shared Hosting

Feb 16, 2008

Hello

Maybe someone can suggest me some software which can be used for SQL 2005 shared hosting?
With database size limit, user number restriction and other features.

Thank you for information in advance

View 3 Replies View Related

Witness Hosting

Sep 14, 2006

Does anyone know where I can get SQL Server 2005 witness hosting? Our primary server is in Vermont and our DR site is in New Hampshire. I would like to set up a witness server somewhere off the east coast. I don't want to have to purchase a new server and pay big prices for colo.

Is there such a thing as witness hosting? Would someone be willing to host my witness and I can host yours?

View 1 Replies View Related

Hosting Sql Database

May 23, 2007

I have a hosting package with network solutions. They tell me that i can only have one sql database... In my app_data folder on my computer web site i crerated, I have three of the main folders... does that mean that i have to merge all of those into one...

Another question, Since having many tables, functions etc how could i copy and paste if i have to merge those, because my express editon, i have no idea how to do it... and in visual web developer I'm not able to copy and paste between data folders??

Can anyone please clarify...

Thanks a milion

View 4 Replies View Related

Hosting Options

Jan 4, 2006

Hello,

 

I have been attempting to locate a hosting company that offers SQL Server 2005 in addition to Analysis & Reporting Services but have been unable to find a hosting company which does so without purchasing the entire server. Anyone know of a company?

 

Thanks in Advance,

Garrett

View 1 Replies View Related

Hosting Services Is ?

May 23, 2008

Hi,

I see < SQL SERVER 2005 EXPRESS EDITION LICENSE>
it has "hosting services" (at 4.Scope of License ),(Now, English has been removed, but the Chinese Simplified were)
it refers to what ?


it is means

1. Services Host -> supply app run environment, like IIS
or 2.Server -> Waiting for the link (Server)




PS. SQL SERVER COMPACT 3.5 can also use it


thanks


View 1 Replies View Related

Hosting A Dedicated SQL Server

Mar 14, 2007

I have a server that i would like to use as a dedicated DB Server. It is running Win Server 2k3 and SQL Server 2005. The typical upstream bandwidth is anywhere from 384Kb/s to 700Kb/s. Is this enough to host multiple SQL Server 2005 DB's?
 The DB's will be used for database driven websites.
 Please let me know what your thoughts are.
 Thanks,

View 1 Replies View Related

Why I Am Getting This Error While Hosting Time

Jun 22, 2007

I am using .Net 2005 and sql 2000. While hosting time i am getting this kind of error...Should i Change any setting in sql and .net
 
"Sql 2005 does not allow remote connection"

View 2 Replies View Related

[sql] Is Anyone Using/familiar With Godaddy Hosting?

Jul 22, 2007

Hi all, I'm a  newbie of SQL.  I built a website using SQL 2005, and the data control was using a dataset and wizard,now when I'm uploading the website + database,I learned godaddy doesn't support database uploading.I have to create an empty SQL database on godaddy's sql server, and reDir the connection in config file. my question is, where should I copy my dataset commands to godaddy's sql server?2nd, how do I invoke them in asp.net? thanks in advanceyonk 

View 1 Replies View Related

Aspnetdb.mdf On Hosting Server ?

Aug 5, 2007

 I have established roles to restrict access to the data
entry pages.  The database is SQL Server which I've established on the hosting server.  Security was previously maintained through
~/app_data/aspnetdb.mdb (MS Access).  It works, but isn't too stable, so I have modified the security to use
SQL Server with an aspnetdb.mdf file, also located in the app_data
folder.  Is this appropriate?  Since it doesn't work, I assume not.It's now my assumption that I need to setup a SQL Server
database to support the security/roles.  I have seen some reference to
using a script to build the aspnet.mdf on the hosting server.  If
I do create such a database, is there anything special I need to do to
have my application read the aspnetdb?  Do I need a connection string
in the membership and/or roleManager sections of my web.config.
A little guidance would be appreciated.Thanks 

View 4 Replies View Related

Using Aspnet_regsql.exe To Syc To Hosting Sql Server

Aug 12, 2007

I have been reading on aspnet_regsql.exe tool and still haven't found my answer.  So here we go... I am using VWD Express and I have already made many pages in many dbs within the app folder.  My question is how do I use the  aspnet_regsql.exe tool to know what DB that I want the tool to know AND how do I put in the name of the DB on my sql hosting server?  For instance:Let say in my app folder I have a DB named testDB.mdf and my hosting sql server is named sqlHostingServer...  so if I use the command line entry in accordance with the documentation, it should look like this (in the dos prompt):aspnet_regsql.exe -E -S localhost -d testdb.mdf -A all -sqlexportonly c:output.sqlbut it seems that for the DB name I can put anything I want and still gives me output... wtfark... any help?  I don't work at Microsoft so please simple documentation or something like that.Thanks,MR 

View 4 Replies View Related

SQL Server Web Hosting Tool

Dec 15, 2003

Can anyone recommend a good tool for administering my database ? It is located on a hosting service, however, they donot allow the use of the SLQ server admin tool since there are security concerns..

View 1 Replies View Related







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