We will migrate our SQL 7.0 databases into SQL 2000 on another server. Since I have hundreds of DTS packages on my Repository, is there a better way of transferring to the other server's Repository then ... Package -> Save As -> choose server and location etc,etc...?
Thanks, Suat.
Hello,
I want to move a db from a SQL server 7 to SQL Server 2K. I'll do a backup and restore function to move the database, but how do I handle the objects mentioned in the header ?
Bothe servers (old and new) will have the same name, as well as the DB
All help is appreciated !
Thanks
We manage some SSIS servers, which has only SSIS and SSIS tools installed on them and not the sql server DB.
SSIS packages and configuration files are deployed on a NAS. We run the SSIS packages through DTEXEC by logging in to the server.
We want to allow developers to run their packages on their own on the server, but at the same time we dont want to give them physical access on the server i.e we do not want to add them into RDP users list on server properties. We want them to allow running their packages remotely on the server.
One way We could think of is by using powershell remoting and we are working on that. But is there any other way or any tool already present for the same.
I am using transfer manager in SQL 6.5 to copy a database and
all objects with data to another server. Transfer manager is not recreating all stored procedures. This even happens when I used it to another database on the same server. Any ideas??
Is it possible/advisable when transfering very large amounts of data from server to server to:
trasnfer the data to a new table first
second alter new table adding indexes, defaults, ets based on original table
if it is what flow item would be used to transfer/alter the indexes and defaults?
I'm very new to ssis so the more detail you can give the better.
Thanks
I've run into a problem with SSIS packages wherein tasks that write or copy files, or create or delete directories, quit execution without any hint of an error nor a failure message, when called from an ASP.NET 2.0 application running on any other machine than the one where the package was created from. By all indications it appeared to be an identity/permissions problem.
Our application involves a separate web server and database server. Both have SQL Server 2005 installed, but the application server originally only had Integration services. The packages are file system-deployed on the application server, and are called using Microsoft.SqlServer.Dts.Runtime methods. For all packages that involve file system tasks, the above problem occurs.
When the above packages are run using the command prompt (either DTEXEC or DTEXECUI) the packages execute just fine. This is expected since we are using an administrative account. However when a ShellExecute of the same command is called from ASP.NET, the same problem occurs.
I've tried giving administrative permissions to the ASPNET worker process user to no avail.
I have likewise attempted to use the SQL Server Agent job approach but that approach might not be acceptable for our clients since it means installing SQL Server 2005 Database services on the application server.
I have read the relevant threads in this forum, namely http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1044739&SiteID=1 and http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=927084&SiteID=1 but failed to find any solution appropriate for our set up.
Anybody got any idea on how to go about this?
Hello:
I have been trying to run transfer manager to transfer all of the data
from the production database on one server to a test database on another
server(to refresh it). In order to make sure it runs on the server, I have
been scheduling it under EM to do so and I am pointing to the log on the
destination server on the EM Transfer panel.
For some reason, I am getting the following message in the destination
server error log:
99/02/16 10:24:41.42 ods Error : 17824, Severity: 10, State: 0
99/02/16 10:24:41.42 ods Unable to write to ListenOn connection
'.pipesqlquery', loginname 'sa', hostname 'TEMP09'.
99/02/16 10:24:41.42 ods OS Error : 232, The pipe is being closed.
99/02/16 10:24:41.42 spid17 Error : 1608, Severity: 21, State: 2
99/02/16 10:24:41.42 spid17 A network error was encountered while sending
results to the front end. Check the SQL Server errorlog for more
information.
I checked the event viewer error log and see no messages for today.
Can any one advise me what I need to do for this to run successfully?
Thanks. Any information furnished will be greatly appreciated.
David Spaisman
Hi all
Our data management system currently runs DTS packages using DTSPKG.dll.
I am currently looking at the possibliity of replacing the DTS packages and SQL 2000 with DTSX packages using SSIS in SQL 2005.
Do I need a new dll? or will the current dtspkg.dll handle the new DTSX packages?
Many thanks in advance!
I was trying to transfer a SQL Server 2000 database to SQL Server 2005 using SQL Server Objects Task. However, The following error message was encountered: "[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Cannot apply value null to property Login: Value cannot be null..".€œ
View 12 Replies View RelatedSQL Server 2005 - June CTP
View 7 Replies View RelatedI have a corrupt master db due to a rogue script that inserted lots of information into it. I have two SQL servers, and I could use some advice on the best way to copy the files over to the second server, then back after a reload of the first server. My main concern is the DTS packages I have built- I can't afford to lose those.
View 4 Replies View RelatedHello. Firstly apologies for what might appear as a basic question, but being a newbie and all :-). .
I have a SQL 7 DB, loads of sp, vw, tables etc. I want to copy this DB to another server so that all the DB and sp permissions stay current, all the sql logins come across etc etc.
I have tried restoring a backup to the new server (which worked fine), but then I appear to have lost the permissions for the tables and sp's.
I have then tried taking a copy of the original SQL master table and restoring this to the new server - but no luck.
Can anyone advise a sure method of copying an entire table and related entries (meaning sql logins etc) to a new server.
Appreciate any comments.
Regards
What will be the best way to transfer database from sql to oracle server. I have almost 50 databases in sql, I dont want to create a dts for each and every database to transfer-- Is there a process to transfer entire database at one time
Josephine
Josephine
Hi
We are planning to upgrade from sql server 7 to sql server 2000.The sql server 2000 will be installed on another server.
If we have to move back from sql server 2000 to sql server 7 (if there are any problems on sql server 2000).is there a way to do it?
Is there a way to restore the changes made on sql server 2000 to 7?
Thanks
Madhukar
I am replacing a server so I need to migrate everything. The old server is running SQL2000 and the new server is running SQL2005. I am trying to write an SSIS solution to migrate everything for me and I can't even get started because I get the error "The source server can not be the same as the destination server". At the same time I am changing the name of the Domain so the two machines arenot even members of the same Domain. I am doing this over the Internet so the machines are not even on the same subnet. The only thing I can think of is that the machine names are the same so even though the domains are different therefore the full names are different, the NetBIOS names are the same. Could that be the problem?
View 1 Replies View RelatedHi!
I have two servers. Server A and Server B Both the servers are in different domains and both have different names.
Server A runs a clustered sql server (sql 2005 standard sp1)
Server B also runs a clustered sql server (sql 2005 enterprise sp1)
Both server A and Server B has same virtual server name X.
So, when I try to copy all the logins from server A to Server B using Transfer Login task in ssis, I gert the following error-
"Source Server Can not be same as destination server"
I am using IP addresses to connect to both the servers.
How do i solve this issue now?
Thanks
Hi
I think I must operate a similar system to the rest of you here, where I have a Shared SQL Server Database on the web for my website and since I cant afford the full SQL Server to develop on I'm developing on the MSDE that comes with VS.net(I think thats where I got it longtime ago). Anyway my point is since in the database project on VS.net I cant generate Create Table SQL Code against MSDE, Apparently you need the full SQL Server to do that. Whats the best way for me to transfer any changes from my dummy development database to my production database on a real SQL Server.
Any help would be appreciated I'm still rather new to SQL Server(been using cheap MySQL) so could do with some pointers.
Thanks
Andy
Hi,
I have several databases on one MSQL Server which I want to transfer to new server. So, basically it is tranferring all contents of sql server databases on one server to another one. I know I can use import Wizard, but it will take long time, is there a more better way to do this.
Thanks,
Mashro.
Hi
I was wondering if any one out there could help me out here. We are using SQL Server 7.0, we have purchase a new server, what will be the best procedures to transfer the current database to the new server? I look forward to hearing from anyone, also I wish you all a Merry Christmas & Happy New Year.
I shall remain.
E. Warden
Hi,
I am new to the database concepts, maybe my questions are very basic.
I transfered data from one sql server to another thru object/database transfer. The transfer was successful, ie.,
all the data was present in the new server too. I am using an application with ASP as front end and SQL server 6.5 as back end.
So i am able to all new records, delete them, update them thru my ASP programs. But, i am not able to update the records
which where transfered from the old server. I hope some one of can help me, as i said earlier i am new to databases,
so give me a detailed solution.
Thanks,
Karthik narain
I have two servers running SQLserver 7.0. I have a number of DTS packages/jobs that are configured to import files each day. I do not want to recreate these packages on the second server, for it took quite sometime to set up only one. Can I copy these packages to my second server. Please help!
View 2 Replies View RelatedPlease give me a direction where to go to solve this problem...
our organization regularly pumps data from an AS/400 database (db2) to SQL Server 7 tables with the help of DTS. Some of the data transfers are straight column copy and several are ActiveX transformations. Also, we've got some of the transformations defined directly inside the select statement in the Source tab of the DTS designer. There is one stored procedure which collects and does computations with the data to put into a number of Excel reports. The strange thing is that some of the data seems to be getting corrupted somehow as it is transferred, because the resulting data in sql server is not identical to that which was transferred. We get outrageously high values for one of the columns with no apparent pattern. There are no error log entries for this, and we've already confirmed that all the transformation scripts and stored procedure functions that we've been using are correct. Would doing a server trace be of any help, and if so what should I be looking for and could you just brief me on how to start one, since I've never had the need to do one so far. Thanks for the help in advance.
I want to move a DTS package from one server to a new server.
I know I can do a "Save as" and then redo all the different property settings once on the new server....but is there a way to do a Import/Export through the wizards ?
I tried this method, but was not able to choose a DTS package...only thing I was able to choose was database, tables, views, etc., but no DTS package.
Thanks for your insight
Does anyone know of a script that will transfer a 6.5 database on server "A"
to a 7.0 database on server "B". Currently I am using Microsoft Access to
export the 6.5 data and the import to a 7.0 server database. The problem with
this technique is that the field NULL settings are changed and the primary key
settings are changed.
Thanks,
Jim
we have 2 sql server 6.5 . i want to transfer the data of one to the other .both have the same database.
thank u
vineet
May I know how to transfer Microsoft SQL Server's database from 1 PC to another PC?
What I doing now is export the Microsoft SQL Server database to Microsoft Access format, then import it to the SQL Server of another PC.
But the field type have to reset again.
Any method that the table's field type is same after transfer to new PC?？
＊field type = int, varchar etc
Thx~
when i do the experiment,i have some questions
1.when i click 'finish',it shows me :
14261:primaty_server_name.primary_database_name ('(') already exists
2.when i use: use msdb
exec sp_change_secondary_role 'northwindlogshiop
it shows me :server:message:22029,level 16
sqlmaint.exe failed
3.
when i use
use msdb
exec sp_change_monitor_role 'primary_server','secondary_server','northwindlogs hip','c:productionlogs'
it shows me :
server:message 14442,level 16,procedure sp_change_monitor_role
row 18,change role failed
can u help me .thanks in advance
hi can somebody help me out on this.. is there a way to consolidate the data in different Sql Server 2005 database servers scattered at different locations into a single database without using REPLICATION.
p.s Data transfer should also be conditional and bi-directional
Ive have a website on SQL Server 2005 on my Localhost, that I need to transfer to a live test server, in MYSQL you can use dump to get the SQL script,can I do this in SQL server? If so how? if not how do I transfer the DB?
View 5 Replies View RelatedNew to sql scripting and am having a problem. I have two SQL servers:
1. Keeps track of all sales related activities.
2. I would like to use for backup and reporting of sales only.
I am wondering if there is a script that can be run to transfer only specific data from the first server to the second, and if so what is the setup and syntax.
I am looking to do something like:
insert into [database#2] [table]
* from [database#1] [table]
where database#1-table.result='Sale'
Please help...
Thanks.
there is applications which were written in FoxPro. Recently it has been redone in SQL.
How can I check that Whether their server designated to host the database is ready and fully up to spec on revs and patches,If not how and who can bring it up.
and How can I determine what else needs to be addressed to ensure a smooth transition and implement?
Define ongoing maintenance requirements.
Is there a way to set up the "Transfer SQL Server objects" task and have it dynamically copy of certain tables/data? I see the TablesList values in the "Objects to copy" section and I'm seeing it can be an expression (which I can assign a variable too), but what value is that string if you have multiple tables?
Thanks,
Phil
Does anyone know the most efficient way of transfering linked servers between databases with out manually recreating them?
I can't seem to script them, I looked into the sysservers table, I don't want to insert into a system table until I have to?
There has to be a better way, has anyone run across this in SQL 2000?
Thanks