Here's the situation....
1. Local dev environment is VS2005 and VS2008 / using SQL Express databases
for data
2. Hosting company ONLY supports MS SQL Server 2005 databases
Here are the questions...
1. Should I develop using SQL Express, or would my life be easier if I had
my local dev machine connected to a local SQL Server db? Any advantages or
disadvantages?
2. After I'm done developing the website I want to deploy it in such a way
that if I have to change the database schema (add fields, tables, etc...) in
the future it's easy to do. Any recommendations ?
I guess I'm not quite sure as to what is the "proper" way to make db changes
to a db already in production (changes to schema, fields, tables, etc...)?
I'm kind of lost.
What is the best way to do this?
1  1047 
There is NO DIFFERENCE between a SQLEXPRESS database and a SQL Server 2005
database. The only issue you may run into is the fact that SQLEXPRESS can use
the "User Instance" connection string which web hosting companies do not
support, as it is only supported for localhost operation. Download the Sql
Server "Database Publishing Wizard" (free from Microsoft) to create a SQL
script that allows you to migrate your local database to your hoster. Take
the time to "RTFM".
-- Peter
Site: http://www.eggheadcafe.com
UnBlog: htp://petesbloggerama .blogspot.com
Short Urls & more: http://ittyurl.net
"Bobby Edward" wrote:
Here's the situation....
1. Local dev environment is VS2005 and VS2008 / using SQL Express databases
for data
2. Hosting company ONLY supports MS SQL Server 2005 databases
Here are the questions...
1. Should I develop using SQL Express, or would my life be easier if I had
my local dev machine connected to a local SQL Server db? Any advantages or
disadvantages?
2. After I'm done developing the website I want to deploy it in such a way
that if I have to change the database schema (add fields, tables, etc...) in
the future it's easy to do. Any recommendations ?
I guess I'm not quite sure as to what is the "proper" way to make db changes
to a db already in production (changes to schema, fields, tables, etc...)?
I'm kind of lost.
What is the best way to do this?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Rick Muller |
last post by:
I have a problem that I would like to get some advice on from other
Pythonistas. I currently manage a (soon to be) open source project for
displaying molecular graphics for a variety of different programs. To
do this I need to draw pictures of the molecules, typically using
OpenGL, and do some basic control, using some widget set.
The code...
|
by: Nick Malik |
last post by:
reposting to a wider audience
"Nick Malik" <nickmalik@hotmail.nospam.com> wrote in message
news:WYONc.203854$XM6.119642@attbi_s53...
> My turn to ask a question
>
> I am working on a plug-in for Sharepoint that will allow a developer to
add
> workflow rules. One of the rules will inform the adapter that it should
> load a DLL that the...
|
by: tgh003 |
last post by:
I would be interested to hear how others are managing their javascript
(.js) files from the original code vs the obfuscated version they
publish to their site/webapp.
I currently manage 2 files, and everytime i need to make a change, I
have to switch the names, test, then rename again, obfuscate to the
original file name (because this is...
|
by: Nick Malik |
last post by:
My turn to ask a question
I am working on a plug-in for Sharepoint that will allow a developer to add
workflow rules. One of the rules will inform the adapter that it should
load a DLL that the developer writes, find a method that matches a
particular interface, and call it.
I know, in general, I should be looking at the reflection...
|
by: Laban |
last post by:
Hi,
I find myself using static methods more than I probably should, so I am
looking for some advice on a better approach.
For example, I am writing an app that involves quite a bit of database
operations on purchase orders and inventory. I have created a PurchaseOrder
class and Inventory class to encapsulate operations like creating POs,...
| | |
by: Lloyd Dupont |
last post by:
I need to convince my boss to use ASP.NET
We will start a new web project soon.
he is hesitating between JSP, and ASP.NET.
I think I could convince him ASP.NET would be faster to develop, easier to
deploy.
(he is hard to convince, I suspect him to be afraid everone is antimicrosoft
as 90% destop seems to prove!)
|
by: David Van D |
last post by:
Hi there,
A few weeks until I begin my journey towards a degree in Computer
Science at Canterbury University in New Zealand,
Anyway the course tutors are going to be teaching us JAVA wth bluej and
I was wondering if anyone here would be able to give me some tips for
young players such as myself, for learning the language.
Is this the...
|
by: george.leithead |
last post by:
Hi all,
I'm looking for some advice on how best to achitect the following
requirement.
I'm basically writing a Fantasy Football (FF) Web site, and would like
to have it fully OO and have it using as much inheritance, base
classes, common methods, etc as possible.
My biggest headache that I cant get my head around is how to handle
|
by: MPA |
last post by:
Hi,
We are a small company with experience in client-server apps with
PowerBuilder and most major databases. We have no internet experience. We
are now looking into slimming our main application, rewriting it with
DOT.NET and making it accessible for Internet browsers. Our app constists of
hierarchical tree (with usually several hundred...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
