Deploy Sql Server Express DB to Sql Server Express

I have developed by webite with Visual Studio 2005 and sql server express.

I'm trying to deploy my website to a VPS with sql server express running on it

I ftp'd the App_Data folder to the remote via the 'copy web site'

Everything seemed okay until I started trying to run more complex database operations using stored procedures and transactions. It appears that the schema is messed up because when defining the parameters for a stored procedure, upon ExecuteNonQuery I get the error that I've assigned too many parameters which I have not (since it runs fine on my local computer).

Is there a way to ensure that the schema is setup, etc. That is, is there a procedure to go through to transfer a sql server express DB to another sql server express running on a remote server? In all this complexity, simply copying it and setting up the connection strings seem suspiciously too simple.

Any help will be greatly appreciated!

Thanks!

Gretchen

0
gretchen
8/29/2008 2:40:56 AM
asp.net.sql-datasource 29906 articles. 0 followers. Follow

1 Replies
1022 Views

Similar Articles

[PageSpeed] 42

FYI: Well, thanks to the excellent tech support at ServerIntellect.com, they fixed the problem - it was a permissions issue.
Thanks,
Gretchen

0
gretchen
8/29/2008 6:06:14 PM
Reply:

Similar Artilces:

Converting MDF files (SQL Server Express) to SQL Server 2005 WITHOUT having to buy SQL Server 2005 (I have Express). Personal WebSite Starter Kit
Hi (and HELP!),   I downloaded the Personal WebSite Starter Kit and got it working no problem on my local machine.  But I've had nothing but frustration trying to get it up and running on a webhosting site.  I picked hostmysite.com which uses SQL Server 2005.  I was under the impression that it wouldn't be that big a deal to convert the .MDF files that Sql Server Express uses to a SQL Server 2005 database.  I tried using SQL Server Management Studio Express.  I was able to "see" my remote database on hostmysite.com, but I was not able to import the .mdf file...

Converting MDF files (SQL Server Express) to SQL Server 2005 WITHOUT having to buy SQL Server 2005 (I have Express). Personal WebSite Starter Kit
Hi,Basically i built a webpage with Login and it's working well from my local machine.Right now, i'm using Database Publishing Wizard. the problem is how do i convert.MDF files to .SQL 2005 to get my database publish in the internet? thanks  Place your .MDF file in the App_Data directory, change the connection string accordingly and then publish your web site. ----------------------------------------------------------Please click Mark As Answer if this helped in solving your problem.  Please click "Mark As Answer" if this hepled in solving your problem. ...

Converting MDF files (SQL Server Express) to SQL Server 2005 WITHOUT having to buy SQL Server 2005 (I have Express). Personal WebSite Starter Kit
Hi (and HELP!),   I downloaded the Personal WebSite Starter Kit and got it working no problem on my local machine.  But I've had nothing but frustration trying to get it up and running on a webhosting site.  I picked hostmysite.com which uses SQL Server 2005.  I was under the impression that it wouldn't be that big a deal to convert the .MDF files that Sql Server Express uses to a SQL Server 2005 database.  I tried using SQL Server Management Studio Express.  I was able to "see" my remote database on hostmysite.com, but I was not able to import the .mdf files ...

SQL Server 2005 Installation problems with SQL Server Express & SQL Server 2000
Hi Guys, I have had SQL Server Express and Sql Server Management Studio Express installed on my machine for some time and recently tried to install a trial of SQL Server 2005 as well.  (Yes, I'm migrating from Visual Studio Express to Visual Studio Professional, just as in tended!) Everything went fine except that nothing seemed to be installed.  I searched in all the obvious places - both on the Start/Programs menu and on the hard-drive: nothing. A check under Add/Remove Programs showed that Sql Server 2005 Express was installed, but called SQL Server 2005. So after a number o...

SQL Server Express deployed to SQL Server Problem
I am developing an application using VWD 2005 Express with SQL Server 2005 Express. The application works fine on my development box. My production box is running the full-blown SQL Server with ASP.Net 2.0 and IIS. I'm having problems getting the database connection correct. The SQL Server on the production box does not recognize the SQL Server 2005 Express (SSE) *.mdf file. I tried attaching the SSE *.mdf file to the SQL Server, but I get an error message. Has anyone had this experience? Can anyone give me some suggestions. It seems like I should be able to attach an *.mdf file cre...

sql server and sql server express
ok i am puzzled right now....i have a web application connecting to a sql server database....i uninstalled sql server express and installed sql server 2005 full version...i changed the connection string in my application to be Data Source=SKYBANDR62;Initial Catalog=aspnetdb;Integrated Security=True and through the explorer bar i can access my database freely but when i run my application i get this error Server Error in '/' Application. -------------------------------------------------------------------------------- An error has occurred while establishing a...

How do I synchronise local SQL Server Express db with my online SQL Server 2005 db?
For various reasons, I have a situation where the data in the SQL Server 2005 database hosted by my ISP is more up to date than the data in the matching SQL Server Express database on my own PC. I now want to synchronise these two databases but don't know how to do it. Because I am still developing my ASP.NET 3.5 app, which has not yet been opened up to users, I am only used to synchronising in the other direction by first using the Database Publishing Wizard within Visual Web Developer 2008 Express to create a suitable script associated with my SQL Server Express database and then runn...

SQL Server 2000 DB in SQL Server 2005 Express
I have an SQL Server 2000 DB that I created on one PC that I would like to move to a PC running SQL Server 2005 Express, is this possible? Will the SQL Server 2000 DB run under SQLS Server 2005 EXPRESS? Thank you for any thoughts, Yes, there are serveral ways to move the database: backup/restore, detach/attach, Copy Database Wizard, etc. For more information, you can refer to:Copy Database Wizard: http://msdn2.microsoft.com/en-us/library/ms190775.aspxBackup/Restore: http://msdn2.microsoft.com/en-us/library/ms190436.aspxDetach/Attach: http://msdn2.microsoft.com/en-us/library/ms190794.a...

How to connect to my sql server express,also Pubs and northwind for sql server express
1, I have installed VWD express,sql server 2005 express.I also install management studio and adventureswork db.In the management studio I can able to connect and view adventurework db.But I can't manage to make a connection string to my db server when connecting to management studio server name is "KAMRANSHAHID\SQLEXPRESS".I wants a connection string with respect to this server.2,Is there new database for pubs and northwind for sql server 2005.Or they are of old sql server 2000.I have installed sample databases but can't find script for pubs and northwind nor it install automatically.I wan't...

Mixing SQL Server and SQL Server Express
VWD 2008 Express.  Visual Basic. I have some questions: 1.  If I create a web site that uses a local database (stored in a directory in my web site's root directory) handled by SQL Server 2008 Express, what happens when I move the site from VWD to my server?  My server has SQL Server 2005 Standard running on it.  Will my site run even if SQL Server 2008 Express is not installed on the server?  Do I need to install SQL Server 2008 Express on my server? 2.  Can my Windows 2003 Server run both SQL Server 2005 Standard and SQL Server 2008 Expre...

SQL Server Express and SQL Server 2005
can any one tell me what the main differences are in the two editions? also can you use and express 2005 edition database on sql 2005? if not how would you do that? Tuppers Look here for a detailed comparison between the two.Yes, you can use Express databases on SQL Server 2005. Just attach it to an instance of SQL Server 2005.Is this enough information?DonDon Kiely, MCP, MCSDIn the Last Frontier, Interior AlaskaPlease post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem! cheers i was told by my host t...

SQL Server Express file to Sql Server
I would like to copy the schema and data of a sql server express database file to a SQL Server Database. How can this be done and what steps would I need to take?   Thanks for any helpTinyPond TinyPond:I would like to copy the schema and data of a sql server express database file to a SQL Server Database. How can this be done and what steps would I need to take? If you have Express Management Studio, you back backup your database, and them import it to SQL Server (or attach and reattach).Justs open SQL Server Express Management Studio, connect to your Express instanc...

sql server and sql server express conflict
hey all please help me ....i have been working on this issue for 2 days i created a web application with a automatically generated security database and added tables to it and it was working fine...i had to a linked server the linked server cannot be added from sql server express so i installed the full version...it was working fine until suddenly i got this error "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed" so i searched and searched then i found out that i cannot have the two ver...

SQL SERVER EXPRESS versus SQL SERVER
Would anyone really use ASPNET2 Membership Services with its built in Sql Server Express database for a major, heavy traffic website? How well would sql server express handle 1 million members? Can anyone point me to an article comparing performance of full blow Sql Server with (watered down?) Sql Server Express? Seems to me you already know the answer to this question in the way you ask the question.  SQL Server express is just for normal web applications for learning/teaching and small time deployment.  Obviously by logic heavy traffic ( esp in the 1 million range even in t...

Web resources about - Deploy Sql Server Express DB to Sql Server Express - asp.net.sql-datasource

The Indian Express: Latest News, Breaking News Live, Current Headlines, India News Online
Indian Express covers latest news from India, all exclusive current headlines and India news live, including latest breaking news on business, ...

Local news, sports, obituaries, classifieds and more - Tallmadge Express
NEWARK, N.J. (AP) Gov. Chris Christie, who once famously called himself "the healthiest fat...

Sussex Express
Search continues for boy swept out to sea at... The search has continued today (Monday October 28) for the 14-year-old local boy who was swept ...

PCI Express - Wikipedia, the free encyclopedia
... standard support hardware I/O virtualization. The PCIe electrical interface is also used in a variety of other standards, most notably ExpressCard ...

Fred Armisen in his feminist bookstore persona Candace Devereaux reads "Portlandia Travelogue: The Brussels ...
Downloadable free here . A literary train journey on the Brussels to Antwerp Express through the erotic world of European train stations and ...

Walmart Closing 154 Stores In U.S., Ending “Walmart Express” Experiment
Walmart’s five-year dalliance with trying to go small through new “Walmart Express” stores is apparently over. This morning, the company announced ...

Jackson Hewitt Teams Up With American Express To Target The Underbanked This Tax Season
... and underbanked, taxpayers who have their taxes prepared at Jackson Hewitt can opt to have their federal tax refund added to an American Express ...

Siberian Express Expected to Send Temperatures Plummeting
Siberian Express Expected to Send Temperatures Plummeting

Jawan remanded to 7-day police custody in Howrah Express rape case
The army jawan, who was arrested in connection with the alleged gangrape of a teenager inside a compartment of Howrah-Amritsar Express, was remanded ...

Meet Uman, The Gender Fluid Artist Who Taught Herself To Express
Born in Somalia and raised in Kenya in a Muslim household, Uman is redefining outsider art in NYC.

Resources last updated: 1/16/2016 12:31:04 AM