We have a SQL 7 server SP3 which we want to replace. The initial plan
is to create a new SQL 7 server and restore the database backups.
My first question is there any need to restore the master database
once all the other db's are copied.
We had planned to copy the databases and the msdb.
Do all the DTS jobs, users, security etc come over in the msdb.
Also is there any reason why we shouldn't upgrade to SQL 2000, are
there any compatiability issues with restoring the SQL 7 database
backups to the SQL 2000 server?
I have developed a database on my local machine using MSDE. I am using Visual Studio.net to add tables/stored procedures to the database. I have created asp.net pages. I need to get this database on a web server that runs Enterprise SQL Server. Can I just use the 'sp_detach_db' and 'sp_attach_db' to move the database between servers?
Hi Everyone, I am migrating my old sql server database to the new hardware, in the processes I migrated all the databases from old sql server 7.0 to new sql server 7.0, and also generated the scripts for all jobs and executed in the new server, all the jobs appear but when I go and see in the job steps, I don't see any steps in the jobs, I tried different ways but I am not able to get the steps. Can any one help me out.............. I have about 160 jobs so I cannot make new steps for each and every job.
Hi Everyone, I am migrating my old sql server database to the new hardware, in the processes I migrated all the databases from old sql server 7.0(All tables from MSDB Database, sysjobs, syshistory etc) to new sql server 7.0, and also generated the scripts for all jobs and executed in the new server, all the jobs appear but when I go and see in the job steps, I don't see any steps in the jobs, I tried different ways but I am not able to get the steps. Can any one help me out.............. I have about 160 jobs so I cannot make new steps for each and every job.
I want to do a data transfer but i am not sure how ..from oracle to sql server.
i want to know if its required to install the oracle client to configure so as to transfer data or not.
I heard from someone that if we change the win.ini file entry for oracle.ini and place the tnsnames.ora file i spcified location it will work but it does not what is the way to deal with..
How do i perform this with the odbc configuration for oracle..and use the same in the dts.
Hi Every one, I am upgrading from one computer to another. I have few questions.
1. Is it neccessary to run the SQL Services on Domain User Account on both machines or on 6.5 machine. 2. How to check the all User logins exists in Master database.(I read in BOL that all user logins must exists in Master Database) 3. How much time it will take to complete for 10 GB database.
Please give me anohter suggetion which will help in this regard.
Can any one tell me the steps to migrate sql server 7.0 from one server to another server(Production databases). Its a 24x7 shop. The down time should be minimal. Iam looking for a most efficient way of doing that.
Is it possible to migrate SQL Server 6.5 to 2000? We have an ACtive/Active Cluster Environment. It it's possible, please give me a brief guidance on how to go about it. Thanks for your help.
has anyone migrated a ms sql 6.5 server to a mssql server 7.0 on 2 different machines? and if so how the heck didja do it? the 7.0 server keeps telling me that it cant do it until the 6.5 server is upgraded.....help...help....help....the 7.0 server has the 6.5 one registered it just wont connect to it....tells me that it has to be a 7.0 server.....help
I have to migrate INFORMIX database to SQL Server 7.0 and I was wondering if there is anyone out there with any experience? I want to know the procedures and how to go about it towards a successfully INFORMIX migration to SQL Server. I look forward to hearing from you.
Hi There, Greetings! Many of my clients are on SQL 7.0 (Win NT) and want to upgrade to SQL2K (Win 2003). We have approximately 1200 Stored Procedures (SPs) per module.
Our porting exercise involves changing keywords of SQL 7 to SQL2K (eg. LTRIM, RTRIM, GROUP BY etc).
Is there a tool available online which can run thru the SPs and do the porting job? Otherwise I have to hand-code these changes
Also, has any one out there done this exercise before? What are the things to lookout for to avoid goofups?
How to migrate scheduled jobs from 2000 to 2005. Is this possible by doing bcp out and bcp in system tables which stores sql agent jobs from msdb database ?
In DTS 2000 package dynamic property task an ini file is read and values for some keys are read. These values are nothing but name of servers on which to run some sql tasks. This dts package has three defined connections. So when the keys are read it will be either one of these three.
For eg. there are three sql tasks. sql1, sql 2 and sql3. sql1 needs to be run against server s1, sql2 against s3 and sql3 aginst s2. So the ini file sets three different variables connection1 to s1,connection2 to s3 and connection3 to s2. These variables are then used to run sql tasks accordingly. When I migrated this dts package to .dtsx format and edited using SSIS, it gave me a blank format of vb script which we need to code. please help me out in this issue ?
I try to migrate DTS package to SSIS. Within one DTS package AAA, it calls another DTS package BBB with inner variable. I successfully migrate the BBB DTS package. For my AAA package, I replace the DTS_Execute_Task_2000 with Execute Package task. But how do we pass the inner variable parameter ?
Soon, i will be asked to carry enterprise databases on an Sql Server 2005 Server x86 edition to Sql Server Server 64-bit editon on another server. I am wondering that is it just fine to detach/attach databases. Is there any trouble that i may face?
I created a website using Visual web developer express edition (including SQL Express). No the user management section of the site (the login/logout database) was created automatically and SQL Server express was installed at my computer under the instance name of SQLExpress. I uploaded it to my web host and he hooked up the ASPNETDB for me. Now the problem is that ASPNETDB has an id password and I was given the MSSQL Server IP. How do I configure my website to accommodate that? Any help will be extremely useful!!!
We have an old client server application (vb / sql 2000) we have now converted that application to a web based asp.net / sql 2000. Though the db is same (sql 2000) for both applications, tables/columns has been changed during the development process. Now i need to migrate the data from our old db to this new db. Should this be done the "painful" way of checking each and every table its links/dependencies, columns manually or is there a tool which helps me migrate the data from one db to another (even though the tables/columns are different)Please Help.Thanks.
I have been asked by my boss to prepare for a migration from SQL Server 6.5 & 7.0 to 2000. Also they want me to produce a consolidation process does anyone have an idea how to go about this? I would be more than happy with any suggestion.
I have migrated a database from Access to SQL. Promlem is that I cannot edit the records in the now linked tables. We are still using the Access front end. Why can't we edit the records?
Has anyone had any experience with the Oracle Migration Workbench? or using DTS to migrate MS SQL to Oracle? The Migration Workbench seems to work great but it is having parsing issues with some of the syntax in our triggers and procs (roughly 1025 of them). Are there other ways of handling these errors other than manually cleaning them up?
I have data in tables with the constraints turn on. I would like to remove all the data from the tables and add new data, and also reset the identity back to 1, without dropping the constraints.
Any suggestions??
If I used truncate table, I would have to remove the primary key. If I remove the primary key I would loss my constraints.
I am in process og migrating the databases from SQL 7 to SQL 2000. I was able to backup all the user databases but when I tried to restore the MSDB database in order to copy jobs I get Error message saying it's the wrong version.
Does anyone know how to copy jobs and logins from SQL 7 to Sql 2000.
Dear Friends, I want to migrate from SQL Server 7.0 to SQL Server 2000. I tried to restore the backup from SQL Server 7.0 in the SQL 2000 version. The restoration was successful. Then I created the logins and tried to map database users but it gave an error. How should I solve this problem ? I tried using the Copy Database Wizard but it gave an unspecified error. Please help me.
We are beginning our research to migrate from our current SQL 6.5 and are wondering if we should migrate to SQL2000 rather than to SQL 7. First of all, is this possible or will we need to migrate to SQL 7 before migrating to SQL2000? Also where can I find good resources to learn more about the changes in SQL 7 as well as those in SQL 2000?
Hi all, via ODBC, how to convert the command 'SHOW COLUMNS FROM ...' from MySQL to SQL Server? Is there any document explaining the differences between those DBs?
