Interested to Buy Any Domain ? << Click Here >> for more details...
How to migrate from sqlserver 2005 to sql server 2000
(every one know reverse process of that )
- 2 Answers
- 7509 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / venu
During the process of migrating to SQL Server 2005, many
development organizations will still be forced to support
SQL Server 2000 installations. As a result, a common
requirement is the ability to reverse-migrate: move
databases back from SQL Server 2005 to SQL Server 2000.
Unfortunately, this is not as easy. Backed-up databases from
SQL Server 2005 instances cannot be restored in SQL Server
2000 instances. Nor can detached SQL Server 2005 databases
be reattached to SQL Server 2000.
Because backup/restore and detach/attach are not supported,
the only methods available for moving data from SQL Server
2005 installations to SQL Server 2000 installations are
based on copying data. Data and schemas can be scripted
using a tool such as Red Gate's SQL Packager and scripts can
be applied on the SQL Server 2000 installations. Another
option is to use tools such as DTS or SSIS, both of which
include data copying wizards.
However, copying data and schema is a potentially
troublesome experience. SQL Server 2005 supports many
features that are not present in SQL Server 2000 and can
cause problems during cross-migration. It's important to be
cautious when attempting to develop solutions for both
platforms, and my recommendation is that development should
be done using SQL Server 2000 and the code and data migrated
forward to SQL Server 2005, rather than the other way around.
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
Why do you use the app_code folder in asp.net?
What is a web farm?
Are there resources online with tips on asp to asp.net conversions?
List the asp.net validation controls?
If there are multiple update panels on the page say upd1 and upd2. There is a button placed in upd1. How can you stop upd2 to update when button placed in upd1 is clicked?
Error : The operation couldn’t be performed because ole db provider sqlncli10 for linked server was unable to begin a distributed transaction.00000110 oledb provider for linked server returned message the partner transaction manager has disabled its support for remote/network transactions. I can able to execute the stored procedure in sql server but when i run the web page getting error like above. I did all the configuration. what is the solution?
Where can I get information on cookies in asp.net?
How do you do Client-side validation in .Net?
Explain the difference between codebehind="mycode.aspx.cs" and src="mycode.aspx.cs"?
Why do we need Sessions?
Why asp.net is better than php?
Is razor a programming language?
Which is the parent class of the ASP.NET server control?
How does session id work?
How can we prepairing Interview
