Migrating VS2003 datasource from SQL 2000 to SQL 2005

Is it necessary to convert my VS2003 project to VS2005 before converting the datasource from SQL 2000 to SQL 2005? Or can I just change the datasource without converting the project?

0
delossan
6/4/2007 4:34:35 PM
asp.net.migrate-vs2003-vs2005 590 articles. 0 followers. Follow

1 Replies
820 Views

Similar Articles

[PageSpeed] 27

Hi delossan,

For the first question, the answer is no. Both SQL Server versions can work with Visual Studio 2003 and Visual Studio 2005.

For the second question, the answer is yes. Visual Studio 2003 can work with SQL Server 2005.

 

 


Sincerely,
Benson Yu
Microsoft Online Community Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
0
Benson
6/6/2007 9:41:55 AM
Reply:

Similar Artilces:

Installing VS2003 and VS2005 / Sql server 2000 and SQL server 2005 on the same machine
Hey guys, I want to install on the same machine VS2003 and SQL 2000 to study for MCAD and VS2005/SQL server 2005 for ASP.NET 2.0 development.   I used to install two images of WinXP one for .NET1.1 dev and the other for .NET 2.0 but everytime you need to switch from .NET1.1 development to .NET2.0 I need to reboot and launch the other winxp image. any help would be appreciated.  I have been trying to change the world for years, but they just won't give me the source code! Where are you having a problem with this? JeffPlease: Don't forget to click "Mark as Answe...

Migrating from SQL 2005 to SQL 2000
Hi, I need to migrate my application that is currently running on SQL Server 2005 to a SQL 2000 server. Most of the transition seems to go smooth, except the Stored procedures I am heavily relying on (of course ;)). Here is an exemple of code that was working with the 2005 server and is no longer working:  <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:db_igsp2000 %>" SelectCommand="ListerValeursCompteurs" SelectCommandType="StoredProcedure"> <SelectParameters> <as...

migrate data from SQL 2000 to SQL 2005
Hi Everybody, does anyone know how I can migrate SQL 2000 data to SQL 2005 database? I'm trying to create an application that will connect to SQL 2000 database using VS2003 and transfer data to SQL2005 database but it doesn't seem to work. Any suggestion is greatly appriciated. devmetz.  you can use SQL Management studio and use the import wizard to put 2000 data into a 2005 database. check this link out : http://www.aspfree.com/c/a/MS-SQL-Server/SQL-2000-Data-Transfer-is-a-Snap-with-SQL-2005/ hth, mcm ...

Migrate SQL Server 2000 to SQL 2005 Express
We are currently running ZPM 6.3.2.700 and will be upgrading to 6.4. Currently have SQL Server 2000, and connot simply upgrade to SQL Server 2005 Express, as this is not permitted. (Full product to free product) Is there a migration path to SQL 2005 Express and retain current databse content. -- pwright Pwright, I don't think so, but let me see if I can find out... -- Shaun Pond Thanks Shaun The reason we are in this position is that when ZPM was first set up, our user base was around 1,500 and MSDE would not really support this, so full version of S...

Migrating SQL EXPRESS in SQL 2000 or 2005 server
whenever i modified the connection of my current database...I'll always got an error,when asking for "server name"..it says [DBNETLIB...etc]Named Pipes etc error..my current database was SQLEXPRESS and i want to change it as an SQL OLEDB,2000,2005.. but as i said il always got an error..sometimes it says "SQL server does not exit..ODBC" etc...when im entering the "server name"..so i could only used Access or SQLEXPRESS server database.. what should i do with the error?? thanks for helping again..    Do you use SQL connection object for this ODBC connection str...

Migrate Data from SQL Server 2000 to SQL 2005 Server Express
Hello:Does Sql Server 2005 Express support data migration  from Sql Server 2000. Anybody? This is exactly what I need to know too, anyone!?   -- Matthew...

How migrate SQL server 2000 database to SQL Server 2005 Express
I  have a  SQL server 2000 database.I have to migrate it to SQL Server 2005 Express.But I don't know how to do. Is any one can help me ? Thanks You can detach the database using sp_detach_db and then re-attach it to your SSE instance using sp_attach_db.  This should work seamlessly, but back up first, just in case.Adam MachanicSQL Server MVP...

migration from sql server express 2005 to sql server 2000 enterprise
hi, i need some help here,i made a simple data driven website in my development PC, at first, i used MS Access for my data base then i migrate it to sql server express 2005, and it works fine when i try to run it in my development PC with my IIS. but of course i will be deploying it to a real server, in our office were i will deploy my data driven site, we have a PC server Win Server 2003 with SQL Server 2000 Enterprise (im not pretty sure by the name but i know its not a free version, its something like a 2000 sql version with a word enterprise at the end).so my question is, i am developing...

Problem with stored proc, migrating from MS SQL 2000 to MS SQL 2005
I've been migrating some DB from MS SQL 2000 to MS SQL 2005 all works fine but I have one problem with stored procedures. Even if there is actually no errors I get the message "The transaction ended in the trigger. The batch has been aborted.". The record is succesfully deleted but still I get the message above. I know MS SQL 2005 added the try/catch block did they change something else that cause compatibility issues with 2000? Here's a sample : *** DECLARE @Error bit DECLARE @ErrorMsg varchar (100) DECLARE @ContactIDToDelete int SELECT @ContactIDToDelete ...

Migrating Dev/SQL Express 2005 website to IIS server/SQL server 2000
    I have VS.net 2005 and SQL Sever Express 2005 on my Dev workstation, created a new web site based on the Personal site starter kit. I have a Windows 2003 Server running IIS and SQL Server 2000 which I want to move the app to. So the first thing I did was to create a new database on SQL Server 2000, ran the Personal-add.sql Script, and forgot what I had to do to get the ASPNETDB database in place, copied the data, and updated the web.config file's connection string to connect to the SQL Server 2000.  So the web site on the dev PC can connect to the SQL Server 2000 data...

Migrating from SQL Express to SQL 2005
Hi,I move my website to our production server who use SQL 2005 instead of SQL Express.The website was, of course, developped with SQL Express.Where can i find the steps that i need to configure the SQL 2005 server for working with my SQL Express database.Thanks You probably don't need to do anything.  Just attach the database and ensure that any logins you created for your Sql Express are set up on the full version.  The database format is identical.Regards Mike [MVP - ASP/ASP.NET]My site Do i have to change something in this line ? : <add name="MyDB" connectio...

Membership.GetUser() not working after migrating from SQL 2005 Express to SQL 2005 Server
Hey guys, Here's the scenario: I have an ASP.NET 2.0 VB.NET web application which is utilizing the new Membership provider system to manager users.  I originally setup my project using the default Membership provider, which uses the default ASPNETDB SQL 2005 Express database in the App_Data folder.  In this configuration, I was calling the Membership.GetUser() method and passing it a username (string) to retrieve membership info for other users in the system so that I could work with their properties.  All of this was working perfectly. Then I had to migrate all of the data...

Migrating sql server 2005 express database to sql server 2005 database
Hi, I have an application developed using VWD and sqlserver express database. The express database is turning out to be small in size and we need to migrate to larger sqlserver 2005 database. What are the steps for this migration, please list in detail. Regards, Sandyhttp://www.thequinn.infohttp://www.sksdataservices.comhttp://www.infobasket.info Hi Sandy, To move a database from SQL Express to SQL 2005, you can use the following steps. 1. If your database file is attached to the server instance, you will need to detach it first using SQL management studio. If it is under App_Data folde...

Migrate Database from SQL Server 2005 beta 3 to Sql Server 2005 Release
Do you now, How can I move database with datas to release version of sql server? Procedores backup/restore can't help becouse of unsuported version database. Any ideas? What about generate a schema script?  Then run an install of your schema in a new query.  You could at least get the db schema but not the data.Eric RamseurRainbow Portal 2.0 AdminDownload Rainbow 2.0!!Rainbow Code Rainbow Portal CommunityC# 2005 Group but I have many datas...

Web resources about - Migrating VS2003 datasource from SQL 2000 to SQL 2005 - asp.net.migrate-vs2003-vs2005

Datasource - Wikipedia, the free encyclopedia
A DataSource object has properties that can be modified when necessary. For example, if the data source is moved to a different server, the property ...

Inverness Graham Acquires DataSource
Inverness Graham , a lower middle market private equity firm headquartered in suburban Philadelphia, has acquired DataSource , a print supply ...

SmartGlance for iPad for iPad on the iTunes App Store
Read reviews, get customer ratings, see screenshots, and learn more about SmartGlance for iPad on the App Store. Download SmartGlance for iPad ...

Chaitanya Pandit (@chaitanyapandit) on Twitter
Sign in Sign up To bring you Twitter, we and our partners use cookies on our and other websites. Cookies help personalize Twitter content, tailor ...

Data source - Wikipedia, the free encyclopedia
... Data source A data source is any of the following types of sources for (mostly) digitized data: a database in the Java software platform, datasource ...

2ndQuadrant - PostgreSQL expertise from specialists with a source code level understanding of RDBMS ...
PostgreSQL expertise from specialists with a source code level understanding of RDBMS PostgreSQL Planets Gabriele’s PlanetPostgreSQL Gianni’s ...

Tagged entries for CLOUD COMPUTING
Alan Williamson's output as a Java Champion, Blog-City Architect, BlueDragon Creator, Author, Speaker and Internet Guru

Private equity deals
... of biometric identity management systems, applications and services. www.crossmatch.com Inverness Graham Investment has acquired DataSource ...

C# C Sharp and Tutorials on C# Friends.com
Learn the c# langauge to build web applications using our online tutorials with live demos. Participate in our forums and learn from others. ...

JavaScript UI Library, Ajax Components & HTML5 Framework - DHTMLX
DHTMLX offers a rich JavaScript library, UI components & HTML5 mobile framework. Build impressive web apps for both desktop and mobile devices. ...

Resources last updated: 1/20/2016 12:40:36 PM