SQL Server 2000 To MSDE Migration (can It Be Done?)
Jun 23, 2004
Hello,
I have a client that is moving their web ap (which has already been developed) from one host to their own servers. The problem is that they don't have MS SQL Server 2000, but they have MSDE. All the code is already writen to work with SQL SERVER 2000.
I have a couple of questions:
1. Can I safely assume that all this code will work with MSDE and all I have to change is the connection string? For example:
SqlConnection myConn = new SqlConnection(connstring);
In other words, can I still use the SqlClient classes to work with MSDE, or will I have to modify the code?
2. Will it be a problem creating the tables and migrating the data from SQL SERVER to MSDE? Can I use Enterprise Manager to do this?
3. I never had to remotely (or even locally) connect to a MSDE database alone, I always develop with a SQL Server db. Can I use a similar connection string for the MSDE database? Do I have to create a data provider on the local machine? Can you give me an example of a MSDE connection string?
View 2 Replies
ADVERTISEMENT
May 21, 2005
Can you install Sql Server 2000 Developer Edition with MSDE 2000 release A already installed?
View 2 Replies
View Related
Feb 17, 2004
My objective is to use Enterprise Manager to move (copy) my SQL db from the server to my windows desktop computer.
I downloaded MSDE and am having trouble installing it, no doubt because I do not understand the documentaion (ReadMeMSDE2000A.htm).
When I try to run setup, I get that message that says:
"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same."
Considering my purpose, do I need a "strong" SA password? If not, how do I get around it? If yes, how do I set it up?
I am a Mac user so I have poor windows skills, please make it as painless as possible for me, thanks!
Ron
View 3 Replies
View Related
Feb 16, 2006
venu writes "Hi,
Am very new to MS SQL adminstration
Can anybody help me out how to work on Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A just for the practice.
The activity which am going to workout on MSDE is below.
How to install SQL(on XP)
How the layout will be(like if i insall MSDE what are all Application will be and how they depends on each other)
How to create/delete tables if so, how can we do it either by GUI or CUI
just i need a clarifications reg same
Thank you,
venu"
View 1 Replies
View Related
Jan 28, 2002
We are in the process of Migrating our SQL Server 7.0 databases to SQL Server 2000.
We have purchased two new servers for this process.
What is the best method for the Database Migration ?
- Copy Database Wizard ?
- DTS ?
View 4 Replies
View Related
Jul 20, 2005
Dear Friends,I am about to migrate a Visual FoX Pro 7.0 & 5.0 databases to MS SQLServer 2000. I would like toshare the experience with you, if you have undergone such a task. Isthere any utility for achievingthis.Any white paper or link for guidance on the same.I wannted to migrate the whole database to MS SQL Server 2000. Iwanted to migrate the tablestructures and procedures to MS SQL Server 2000.Please shed some light please.RegardsKumar
View 1 Replies
View Related
Sep 7, 2005
I€™m currently evaluating SQL Server 2005 to what advantages there would be to upgrading from SQL Server 2000. Our existing systems make much use of DTS so it critical for us to be able to run SQL Server 2000 DTS packages in SQL Server 2005. Having installed the Enterprise SQL Server 2005 CTP successfully on a new Windows 2003 server and following the advice to install Legacy Components I find the Migration Wizard (under Legacy> Data Transformation Services) fails with the following error after entering source and target dialogs: This wizard will close because it encountered the following error: Additional Information: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index (mscorlib) Also when trying to open a structured storage DTS file I incur another error: Unable to load DTS 2000 Runtime. This component may have not been installed (Microsoft.SqlServer.DtsObjectExplorerUI) This error seems to imply that the DTS 2000 Runtime needs installing. Can this component be downloaded and installed separately?
View 5 Replies
View Related
May 27, 2008
Parameter
Access 2000/XP
SQL Server 7.0
SQL Server 2000
MSDE 2000
Number of instances per server
n/a
n/a
16
16
Number of databases per instance / server
n/a
32,767
32,767
32,767
Number of objects per database
32,768
2,147,483,647
2,147,483,647
2,147,483,647
Number of users per database
n/a
16,379
16,379
16,379
Number of roles per database
n/a
16,367
16,367
16,367
Overall size of database (excluding logs)
2 GB
1,048,516 TB
1,048,516 TB
2 GB
Number of columns per table
255
1024
1024
1024
Number of rows per table
limited by storage
limited by storage
limited by storage
limited by storage
Number of bytes per row
(Excluding TEXT/MEMO/IMAGE/OLE)
2 KB
8 KB
8 KB
8 KB
Number of columns per query
255
4,096
4,096
4,096
Number of tables per query
32
256
256
256
Size of procedure / query
64 KB
250 MB
250 MB
250 MB
Number of input params per procedure / query
199
1,024
2,100
2,100
Size of SQL statement / batch
64 KB
64 KB
64 KB
64 KB
Depth of subquery nesting
50
32
32
32
Number of indexes per table
32
250 (1 clustered)
250 (1 clustered)
250 (1 clustered)
Number of columns per index
10
16
16
16
Number of characters per object name
64
128
128
128
Number of concurrent user connections
255
32,767
32,767
5
View 1 Replies
View Related
Sep 20, 2007
Can anyone tell me how to backup an MSDE database and then restore it to a second server?
View 1 Replies
View Related
Jan 8, 2007
hi,
i must convert my SqlServer2000 to SqlServer2005. I just do it on my Computer and i run a component "SQL Server upgrade wizard" it convert my SQLServer. But now i must do it on my Server Web and if i run that component it give me an error : "must run SQL 6.5" and i don't installed it.
Can i download it with all right migration?
thank you
View 1 Replies
View Related
Feb 16, 2004
Hi Friends,
I am doing my final semester project. It is a migration tool that converts the DB2 PL dialect into MSSQL Server's T-SQL dialect.
I am in need of sample DB2 PL files(procedures, UDFs, triggers) for testing the tool. Please point out me to some DB2 files repository links or if you have some files, please give me the same. I will use this only for testing purposes.
Appreciate your help.
Thanks & Regards,
Jake
View 2 Replies
View Related
Apr 4, 2007
OK so I'm just the Network Admin here, but our DBA's are off doing other stuff. So I thought I may inquire here about how the easiest way to migrate from SQL Server 2000 to 2005? The first server I'd like to migrate is just databases with a few users, no DTS packages or anything like that... The only problem is that there are several hundred db's, so moving them one at a time is not an option. Has anyone here had successful experience with doing this? Thanks in advance for your help!
-Andrew
View 2 Replies
View Related
Mar 2, 2007
I have a fairly large web application that was built with SQL Server 2000 and .NET 1.1. We're planning on moving to .NET 2.0 eventually, but there's a lot of work to be done before that happens. In the short term, we're looking to purchase a new database server and would like to upgrade to SQL Server 2005 at the same time. Is it as simple as recreating our databases on this new system and changing the connection string, or are there other gotchas? As far as what we're doing with SQL Server 2000, it's really nothing more than tables, views, and stored procedures. Thanks in advance for any advice.
View 4 Replies
View Related
Feb 19, 2007
I am in a process of migration our current SQL Server 2000 (Standard Edition with SP3 running on 32 bit windows 2000 server) to SQL Server 2005 (Standard with SP1 running on X64 windows 2003 server)?
For migration does current SQL Server 2000 requires Service Pack 4 Installed?
View 1 Replies
View Related
Feb 5, 2007
Hi all
Currently we are using the MSDE as SQL Server and decide to switch to use the smaller and file based SQL Server 2005 Compact Edition.
Because of update issue we need to merge data from an already installed database into the new compact edition. Are there some tools we could use in our installation routine (InstallShield) or are there some recommendations how we could do this data merging?
Thanks @ all
Daniel
View 3 Replies
View Related
Dec 12, 2005
Venkatesh writes "In MS-Access table a coulmn is specified as Auto number property.
I want to migrate this table into SQL Server.
We can create a new column that has identity property in SQL Server 2000, which simulate autonumber property of MS-Access.
My access table contains 700 records and I need to set the column (ListID) as Auto number. i.e., I m going to modify this
coulmn with identity property.
But I cant set the identity property for the existing column.
Can u pls send me the sql query that modify the existing column(ListId) with Identity property.
Regards
Venkatesh"
View 2 Replies
View Related
Aug 22, 2006
Hi,
I have been asked to look at optimising a Data Migration Strategy for one of our clients. I am quite new to Data Migration (I'm actually a system designer!).
The migration is from a legacy Oracle 7.16 Db to a SQL Server 2000 environment.
The legacy Db has some large tables - 30 Million+ rows
Table/column Mapping is 1:1
At present we are using DTS to import into the SQL environment.
My question is: Is there any way to leverage the Oracle 7.16 export to speed up the migration process?
Any advice would be appreciated.
Many thanks
Mike
View 1 Replies
View Related
Apr 24, 2008
The Environment:
I have an old Windows 2000 BackOffice server (Retail but with no media) that hosts a small database (<50mb) that is hosted on the local SQL Server 2000 installation. The network has 8 PCs that connect to the database via ODBC connections. I just purchased a new server running Windows Server 2003 Standard Edition (OEM).
What I€™m Trying to Accomplish:
I want to decommission the old 2000 BackOffice server and move the database to the new 2003 Standard server. I€™m trying to do this on the cheap, so I really want to avoid spending thousands on a new SQL server license.
Things I€™m Considering:
1) Migrating the database from SQL 2000 Standard to SQL 2005 Express
2) Moving the database from SQL 2000 Standard to MS Access
3) Purchasing SQL Server 2005 licenses and upgrading
4) Purchasing SQL 2000 Server licenses
The options are pretty much listed in my order of preference. I€™d like to move from SQL 2000 Server to SQL 2005 Express, but I haven€™t really found a lot of material on the subject since people customarily go the other way.
Any advice or alternative recommendations would be much appreciated!
View 6 Replies
View Related
May 20, 2005
Will any application developed against SQL Server 2000 Developer
Edition work on an identical platform with only MSDE 2000 installed? I
understand there's a concurrency limit with MSDE 2000 of around 25 (and there's no GUI) but apart
from that, are there any aspects of SQL Server 2000 functionality (from the .NET applicaiton code's point of view) that
are "disabled" in MSDE 2000?
View 1 Replies
View Related
Jun 27, 2006
i went through the documentation but i was not clear on following, here is the scenario :-
a Central server is having SQL Server 2000
3 Remote Locations :- Each having 4-5 no of computers, connected on a Lan, and on one of the machines MSDE 2000 will be running.
My Questions are :-
1. Can remote locations, update data locally and send changes (say in every one hour) to central server. If yes, then how ??
2. Same way they can receive updates from Central Server on whatever was updated on Centra Server or on the 3 remote locations. If yes, then How ??
any help will be highly appreciable.
View 8 Replies
View Related
Aug 2, 2006
I am creating an install program and I'm wondering if there is a
difference between SQL Server 2000 and MSDE 2000? Do they have
different entries in the Registry?
From the documentation that I've read it seems as if they are one and the same.
However, if someone knows how to differentiate between them in the Registry it would be greatly appreciated.
Thanks
View 2 Replies
View Related
Jan 24, 2008
Scenario
Recently moved a SQL2000 database to SQL2005.
Collation on SQL 2000 database server was SQL_Latin1_General_CP1_CI_AS
Colaltion on SQL 2005 database server is Latin1_General_CI_AS
After restoring the SQL 2000 database on SQL 2005 we observed that the database collation was SQL_Latin1_General_CP1_CI_AS. We have altered the database collation to Latin1_General_CI_AS. We understand this will work for all new objects created on the database but existing objects (prior to the collation change) will continue to have the 'SQL_Latin1_General_CP1_CI_AS' collation.
What is the best method to change the collation of the older columns to 'Latin1_General_CI_AS' -
1) Run ALTER TABLE ALTER COLUMN <colname> <datatype> COLLATE Latin1_General_CI_AS <nullability>
on each varchar/char column
or
2) For each table
BCP out data
DROP TABLE
RECREATE TABLE (taking the new collation Latin1_General_CI_AS)
BCP in data
3) Other methods?
Thanks in advance
David.
View 4 Replies
View Related
Feb 12, 2008
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 an ASPdotNET site originally used SQL server 2005 express,how can i migrate my site to the Win Server 2003 and my database from SQL Server 2005 express to SQL server 2000 enterprisewill it work?? if not, what are the possible solution that i can do in cases like mine?i used Visual Web Developer 2008 Express Ed. in making my sites, and its DOES NOT allow databases in SQL Server 2000!!!!!it says "can't recognize the database"i hope you can help me with this.Thanks-SALAMAT PO....=)
View 1 Replies
View Related
Jan 14, 2008
Hello,
We want to migrate our SQL Server 2000 Databases to SQL Server 2005 including all objects, sprocs, views, jobs, securty, DTS Packages, etc. Pretty much everything.. If anyone has done this in the past for enterprise level databases, I would greatly appreciate it if they could send me some documentation, references, pointers.
Thanks
Russel
View 2 Replies
View Related
Jan 24, 2008
Hi
Our costumer is going to install new hardware.
Actually he is using 2 servers which both have windows 2000 server (+ AD) and sql server 2000 installed. On the new servers he will use windows 2003 and sql server 2005 The hard part will be migrating sql server 2000 to sql server 2005. I have read (not 100%, though) the SQL2005UpgradeTechRef document and downloaded SQLUASetup.exe to be ready (microsoft sql server upgrade analyzer software)
But actually i want to know what is best upgrade path and what are your experience. Is there already a got (or better or perfect) document availabe for the sql server 2000 to sql server 2005 sql server side by side upgrade. Please help! thanks
View 5 Replies
View Related
Mar 4, 2008
Hello Gurus:
My database is running right now at SQL Server 2000 Enterprise Edition. We would like to upgrade it to SQL server 2005 Standard Edition.
Since this database was upgraded from MS Access 2000 to SQL server 2000. This database is accessed by a proprietary application. I don't know some of the details about this application.
There is one more issue with this database, replication was implemented earlier and now it is disabled.
I am thinking that to take a full backup from SQL server 2000 and restore it in SQL server 2005. What do you think?
Please let me know if you have any other idea.
I have another question for you. Right now replication is disabled and I restore SQL server 2000 database to SQL server 2005. Would there be any problem when we try to implement replication again?
Thanks in advance.
Regards,
Arunesh
View 4 Replies
View Related
Dec 18, 2003
I am about to setup an application server. This app will generate reports and instead of just having a HTML page up, I am considering running dotnetnuke type portal to offer the userbase a better interface for the reports, info, announcement, etc.
Server isn't too bad (2x1.7Ghz Xeon I think, 2GIG RAM) type of setup (may be little more or less). App doesn't require as much resources, but we are planning for the future )
While I have some resource to play with, I also need to make sure I don't load much that may impact the application performance. In my experience, SQL Server 2000 will take a lot of resources even when not used as much. So I am considering MSDE.
I am curious however, WHAT ARE THE MAIN DIFFERENCES BETWEEN SQL 2000 Server Vs MSDE 2000 ?
Beside no Client tool and mostly command line specific command, what else there to convince that I should go for server vs desktop engine?
Now our company has Enterprise license for SQL, so I am not worried about the cost (well a little maybe), but mostly wondering about performance.
If you think of any reason why I go to SQL Server 2000 over MSDE, please let me. Otherwise, I think MSDE in this case is the appropriate RDBMS to go for.
Regards,
Impu
View 4 Replies
View Related
Jul 23, 2005
Hi all,I just got SQL Server 2000, but I already have MSDE installed. Is there anyreason I would want to keep MSDE around on my computer if I install SQLServer 2000? I use MS Visual Studio 2002 on Windows XP SP2, in case itmakes any difference. I intend to deinstall MSDE before installing SQLServer 2000, but I get the impression from a few posts that some people haveboth installed and I'm not sure why that would be done. What functionalityis in MSDE that is not in SQL Server 2000?Thanks for answering.--Diana
View 1 Replies
View Related
Aug 5, 2004
Here is the scoop:
I have MSDE installed on a production machine together with a bunch of ASP.NET applications. I was asked to replace MSDE with SQL Server 2000 and move every application from MSDE to SQL Server 2000 with minimum downtime.
Did any of you go through a similar process?
What is the best way of doing this conversion?
How to move the backups from MSDE to SQL Server?
Is it possible to have MSDE and SQL Server 2000 coexists for a time while moving stuff around and redirecting every connection?
Any hints or suggestions would be greatly appreciated.
Thanks.
View 2 Replies
View Related
Aug 13, 2004
Hi all,
I started learning ASP .Net using the "Teach yourself ASP.Net in 24 hours". In that book, the applications use MSDE as the database tool.
Now i have started developing some big applications and have installled MS SQL Server 2000 on my machine.
I still have databases on the MSDE.
My question is 'How do i move the old databases from MSDE to SQL Server 2000' ?
Can i uninstall MSDE safely since i already installed SQL Server 2000 ?
Please let me know.
Thank You
:-)
View 2 Replies
View Related
Apr 19, 2005
Hi,
I am developing an web-database application using ASP.net,c# and MSDE. and after the completion of the project i want to deploy the database over the server whichs got sql server professional edition.
Are there any changes to be made while deploying it over the server and also will the connection string for MSDE and SQL client the same ?
Please do clear me the confusions i have got ..
thanks inadvance
View 2 Replies
View Related
Jun 19, 2002
Hi,
I am a VB programmer and we have a VB application that uses Access as its db (~500MB mdb file) using DAO.
We want to upgrade to MSDE/Sql Server because we have clients that will use around 5 connections to the db and others with no more then 20 users.
I was asked to build a simple test program in Vb under MSDE that will
enable us to test few clients working simultaneously (I have few days for that).
There is so much material on MSDE and we just ordered an MSDE Developer
guide book from the Amazon that will arrive in a few days.
The amount of material is confusing like hell and I didn't work with ADO
before, I don't even know if to work with Access 2000 or with a different db, can you advice ?
Do you know of a good sample that show a beginner like me how to access
MSDE from VB using ADO?
If you do please please advice it will ease the pressure and the days are
numbered.
Thanks a lot.
Yossi
View 1 Replies
View Related
May 18, 2006
I developed an app which stored data in SQL 2005, and encrypted some data using EncryptByPassPhrase( PassPhrase, TheData ), DecryptByPassPhrase( PassPhrase, TheData).
One of the implementations of this will have to store the data in SQL 2000, which doesn't support this functionality. Is there a simple data encryption functionality somewhere that I can implement within a stored proc so I can have my app be independent of the back-end data base server?, i.e. so I can have two different stored procedures depending on the back end db, and not to have the front end handle the encryption?
Thanks
Phil
View 7 Replies
View Related
