ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  ASP.NET
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions
 C Sharp interview questions  C Sharp Interview Questions
 ASP.NET interview questions  ASP.NET Interview Questions
 VB.NET interview questions  VB.NET Interview Questions
 COM+ interview questions  COM+ Interview Questions
 ADO.NET interview questions  ADO.NET Interview Questions
 IIS interview questions  IIS Interview Questions
 MTS interview questions  MTS Interview Questions
 Crystal Reports interview questions  Crystal Reports Interview Questions
 BizTalk interview questions  BizTalk Interview Questions
 Dot Net interview questions  Dot Net Interview Questions
 Exchange Server interview questions  Exchange Server Interview Questions
 SharePoint interview questions  SharePoint Interview Questions
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions
Question
How to migrate from sqlserver 2005 to sql server 2000
(every one know reverse process of that )
 Question Submitted By :: Sam
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to migrate from sqlserver 2005 to sql server 2000 (every one know reverse process of that )
Answer
# 1
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 ?    11 Yes 0 No
Venu
 

 
 
 
Other ASP.NET Interview Questions
 
  Question Asked @ Answers
 
Describe the role of inetinfo.exe, aspnet_isapi.dll andaspnet_wp.exe in the page loading process? Perot-Systems1
How can u handle Exceptions in Asp.Net?  4
Difference between application and session ? Satyam5
What is the Difference B/W Finalize() and Dispose() in .Net? HCL7
How to send data through querystring to another page but it should not be displayed in URL EMR2
how to use html code in asp source code?  1
Features of a dataset ? Accenture3
Various types of Page Load functions Net-Solution3
What was the difference between machine.config and web.config files Assurgent8
Where do you store the information about the user?s locale?  1
About duration in caching technique ? Accenture2
Which two properties are there on every validation control?  2
define silverlight and advantages ?  2
17. If I?m developing an application that must accommodate multiple security levels though secure login and my ASP.NET web application is spanned across three web-servers (using round-robin load balancing) what would be the best approach to maintain login-in state for the users?  1
Which tab of the web site administration tool do you use to manage application setting ,debug and tracing?  2
Webconfig file is cofiguration of server or browser? Wipro9
Can we use http handlers to upload a file in asp.net?  2
How do you implement postback with a text box? What is postback and usestate?  1
Define Query Interface,Adref,Release? Microsoft1
can we call webservice in Html form? Microsoft1
 
For more ASP.NET Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com