Using A DTS Package To Copy Data From Database On Remote LAN

Jun 28, 2002

Hi there.

Here is my problem: I'm trying to copy a few tables from an ODBC database located on a PC on my LAN to a SQL Server on a remote server.

To do this I have created a DTS package on the SQL Server which runs smoothly, copying the data as it should, but only as long as it copies the data from the ODBC database on my own computer where I have Enterprise Manager installed. The moment I try to copy data from another PC in the network where Enterprise Manager is not used to execute the DTS package the task fails to run.

I'm quite at a loss here and would very much appreciate a notch in the right direction. Perhabs some source or book which I may read to solve the problem.

/Bakkegaard

View 3 Replies


ADVERTISEMENT

The Remote Copy Of Database X Has Not Been Rolled Forward To A Point In Time That Is Encompassed In The Local Copy

May 11, 2006

Hi,

I set up DB mirror between a primary (SQL1) and a mirror (SQL2); no witness. I have a problem when I issue command:


alter database DBmirrorTest
Set Partner = N'TCP://SQL2.mycom.com:5022';
go


The error message is:

The remote copy of database "DBmirrorTest" has not been rolled forward to a point in time that is encompassed in the local copy of the database log.

I have the steps below prior to the command. (Note that both servers' service accounts use the same domain account. The domain account I login to do db mirror setup is a member of the local admin group.)

1. backup database DBmirrorTest on SQL1

2. backup database log

3. copy db and log backup files to SQL2

4. restore db with norecovery

5. restore log with norecovery

6. create endpoints on both SQL1 and SQL2

CREATE ENDPOINT [Mirroring]

STATE=STARTED

AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)

FOR DATA_MIRRORING (ROLE = PARTNER)

7. enable mirror on mirror server SQL2

:connect SQL2

alter database DBmirrorTest

Set Partner = N'TCP://SQL1.mycom.com:5022';

go

8. Enable mirror on primary server SQL1

:connect SQL1

alter database DBmirrorTest

Set Partner = N'TCP://SQL2.mycom.com:5022';

go

This is where I got the error.

The remote copy of database "DBmirrorTest" has not been rolled forward to a point in time that is encompassed in the local copy



Thanks for any help,

KT

View 8 Replies View Related

The Remote Copy Of Database Is Not Recovered ...

Nov 30, 2007

Hi,

I am having problems setting up database mirroring (SQL Server 2005).
I made a backup of my database and transaction log, I restore this on
my Mirror server with NoRecovery mode. I established the end points and I set the partner
on my mirror server, I then received the error "The remote copy of
database "DBNAME" is not recovered far enough to enable database
mirroring". when attempting to set the partner on my primary server.

The database status on the mirror is "RESTORING".

Please can someone help!

Thanks,

View 3 Replies View Related

Updating A Remote Database Copy

Apr 12, 2008

I have a SqlExpress DB on my server. I have a remote copy for security/backup reasons. Because the DB file(and .bak file) is about 2 Gb, it take a while to copy the whole thing to the remote machine. I believe there is a way to use the log file to simply update my remote copy ratherr than copying whole files, but I don't know what this process is called to research it. I have Brust's book on Sql Programming, but I have not found what I am looking for in there. Can anyone tell me where I should be looking and what this process is called?

thanks,
Steve

View 8 Replies View Related

Getiing A Copy Of Data Bse From A Remote Server

Jun 18, 2007

I am an authenticated user of a remote data base

I can log in and add tables and even I can back up the database .

Good.



But I want to get a copy of the database to my local computer

Is there any way to do this?





_sujithsql_

View 5 Replies View Related

Copy A Database From A Remote Server And Using It On My Local Machine

Sep 14, 2007

Hi and thanks in advance for your help.
 I have a dilemma and I need some expert help with this. I am trying to make a copy of a remote Database and then replicated the DB and it's contents on my local machine so I can build a test site to run data with. I tried to remot into the server machine but I guess that feature is not allowed by the honest of the remote machine. Since I build on my local machine and would like to be able to test data on my local machine.... I would like to copy the remote DB to my local computer and then I can run my test app on my local server. The version of SQL on the remote machine is SQL Express 2005 and I have SQL 2005 on my machine. Please give me how to accomplish this please.
 
Dollarjunkie

View 1 Replies View Related

Synchronize Sql Server Remote Database With Local Copy

Jan 20, 2006

hello all,

I am using vb.net in windows form. I have made a module which is connected to sql server 2000.

Now, I want to have a fresh copy of the remote database of SQL Server at my local computer and whenever there is change in remote database(insertions,deletion or updation), my local database copy may gets synchronized(i.e changes get reflected in this local copy).

Can any one help me? If it is possibel by using Vb.net code, it is very well, and if there is some Sql Server wizard that can help me do that, please reply to me.

Thanks in advance.

View 1 Replies View Related

Copy An Olap Database To A Remote Server Using SSIS

May 2, 2008

How to add a task to copy an OLAP database to a remote Sql server in control flow using SSIS 2005? This OLAP database is existed in the remote server and I just want to replace the existing one with the one just been updated in the SSIS package and the last task in the package is to copy the updated OLAP database and replace the one at the remote server. Hopfully during the copy and paste process it will not screw up the reports that are using the OLAP cubes at the remote server as the report data source. Thanks.

View 6 Replies View Related

SQL 2012 :: How To Copy Data From One Table On Remote Server A To B

Aug 12, 2015

how to copy a content of a table from one remote server to another,. server A does not see server B (B doesn't see A) - I cannot even ping to one from another.I do have SQL Studio installed on server C, which IT team configured to allow access to both A and B.So what I did so far is to periodically:

1. connect from the studio on server C to server A
2. run the following script on server A: SELECT * FROM A.myTable FOR XML PATH('ROOT')
3. copy the result
4. connect from the studio on server C to server B
5. to write something like

DECLARE @xmlData XML;
SET @xmlData = pasting here my result from item 3 above

6. INSERT INTO
SELECT

ref.value .....
FROM @xmlData.nodes('/myElemnet/ROOT')
xmlData( ref );

so it works. now there is a requirement to schedule this update to run periodically and I need to implement it..

View 9 Replies View Related

How To Copy Database And Local Package?

May 16, 2007

Hi All,



I am new to sql server and the database concepts and just started learning. I want to copy a database and local package from a old sql server to a new server. can anybody guide me with the steps? I am very new to this field so if you could give me detailed steps i would very much appreciate it.



thanks in advance,

View 4 Replies View Related

Package ShellPackage Failed For Copy Database

Dec 21, 2005

Hello,

I'm trying to migrate a SQL 2000 database to SQL 2005.  I'm using the Copy Database Wizard and can copy the database using the detach and attach method, but I would rather use the SQL Management Object method.  I get the following error when trying to use this method:

Package "ShellPackage" failed.

This error occurs directly after the following step:

 Event Name: OnInformation
 Message: Transferring data to database RestoreTest from RestoreTest
 Operator: <WANfirst.lastname>
 Source Name: BP-BLM-TESTSQL2_BLM-JCAMPVSSQL2_Transfer Objects Task
 Source ID: {E6765B9E-1B40-49ED-B0CE-F99252AA34B6}
 Execution ID: {213272C4-37E9-4A1E-A5B9-A2F9A61348B3}
 Start Time: 12/20/2005 3:05:58 PM
 End Time: 12/20/2005 3:05:58 PM
 Data Code: 0

The database is created successfully but the data is not transfered.  Also, the logins are created on the new server successfully.  Has anyone seen this error or have any ideas on how to solve this problem?  I would greatly appreciate any help!

Thanks,

Joseph

 


 

View 1 Replies View Related

SQL DTS Package To Process A Remote OLAP Database

Jul 23, 2005

When I start creating a new DTS Package and I choose the Analysis ProcessingTask icon, I only have the option of working with the local MicrosoftAnalysis Server.How can I choose a remote server's Analysis Server in order to process itsdatabase?Thank you

View 1 Replies View Related

Copy Data To Excel File Using Dts Package In Sql Server 2000

Jul 26, 2007

Friends

Any one of you share your knowledge how to transfer data from a database to a excel using dts packages in sqlserver 2000.

I want clear steps how to create a dts package

Appreciate your help

Thanks
satish

View 1 Replies View Related

Copy Database Wizard Error- SQL Server Agent Cannot Execute The SSIS Package

Aug 3, 2006

I am trying to
copy a database from our company's external SQL
Server(production) to our local SQL
Server(development). The Copy Database wizard fails on the step
"Execute SQL Server Agent Job".
Following is the error in the log file.. Please advise


InnerException-->An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

View 7 Replies View Related

Copy Database From Remote Server(6.5) To Local Server(7.0)

May 26, 2000

I try to copy database from remote SQL Server(6.5) to our local
SQL Server(7.0). I try this way: First, in Enterprice Manager,
I try "NEW SQL SERVER REGISTRATION" using "Register SQL
Server wizard". The remote server give me the IP, login name
and password. then, I try connect option by "login using
SQL Server". But I got message say:"specialted server not found,
Connection open,create file". some times say:"client server access
denied..." some times say:"timeout". What's going on here?
So, I can not get going on with "Import data wizard".

Does anyone know how to solve this problem? Any answer would be of great assistance!

Thanks

View 1 Replies View Related

How To Copy All Data From Table1 In Database A To Table2 In Database B ?

Dec 29, 2004

If I want to copy the data from Table1 in Database A to Table2 in
Database B but Table1 column name is code , Table 2 column name is
vesselcode.
(Code = vesselcode)

How to copy all data from Table1 in Database A to Table2 in Database B ?
Do I need to write the SQL statment ? and Can I use Server Enterprise
Manager Tool?Thx a lot.

View 1 Replies View Related

Copy .txt Data Into Database

Mar 25, 2008

Hi Team,

We need to get the data from our third party CRM vendor. CRM vendor will provide us with .txt file on their folder each night and we need to get those data into our database. I know that SSIS should be able to do this for us. Is there any tutorial of how to do this job in SQL Server 2005? Thanks in advance.

View 4 Replies View Related

Copy Database Changes Without Data

Jul 30, 2007

Hi,

This requirement is for our development and test environment. We have a database server which we use for development hence many changes are done on the database objects on daily basis like tables def changes, view def changes, sp changes, new sp etc.

On the other hand our testing team connects to another database server where they perform testing hence any internal test release would need the changes like tables def changes, view def changes, sp changes, new sp etc.

Since testing team already have their test data set in the test environment hence they want to keep their data but new test release should only provide with datbase object changes. The difficult part is, we have over 500 tables and about 1000 views and somewhere about 400 stored procs, so its not possible to manually perform the above task.


I dont do database admin job hence clueless as what would be the best way to accomplish the above. Pl advice.

we are using sql server 2005 on both test and dev environemts.

cheers!
d2

View 9 Replies View Related

How To Copy A Database Without The Data Onto A CD?

Jul 17, 2007

Hi all,
We have a website with a database connected to a SQL server. I need to copy that database without the data onto a CD so I can place the program on another server?

Any help would be greatly appreciated.

View 4 Replies View Related

Copy Tables Data To Another Database

Jul 4, 2007

Hello all,

I'v got a database full with an administration. This database needs to be protected and can not be accessed from the internet. Now we are making an internetpage for the employees and i want to read from the database who's working here.

For the security i want to copy some database data from one database to another... Is that possible? With a script ore something?

Thanks i advance!

Willio

View 10 Replies View Related

Need To Copy All Tables And Data To New Database

Jul 28, 2007

How do i make a new database file and then copy all the tables and data out of an old SQL file into it? I just want to see if rebuilding the file helps with a corruption issue i have been having with the log file.

brandon jelinek
www.ccgspokane.com

View 10 Replies View Related

Copy Table And Data From One Database To Another

Oct 3, 2006

I am working on a migration project.

Doing the standard processing, taking source data in a staging database, where I then create the new target tables, transform the source data into the new target table structure, and load the data.

However, having created the new target tables in my staging database, I cannot accurately migrate these tables into the new database.

An example table.

The following is the script created by SQL Management Studio if I right click and script the table as CREATE.
CREATE TABLE [dbo].[tbPRO_Package]( [PRO_PackageID] [int] IDENTITY(1,1) NOT NULL, [CreatedDate] [datetime] NOT NULL CONSTRAINT [DF_tbPRO_Package_CreatedDate] DEFAULT (getdate()), [CreatedBy] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_tbPRO_Package_CreatedBy] DEFAULT (suser_sname()), [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_tbPRO_Package_ModifiedDate] DEFAULT (getdate()), [ModifiedBy] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_tbPRO_Package_ModifiedBy] DEFAULT (suser_sname()), [GUID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_tbPRO_Package_GUID] DEFAULT (newid()), CONSTRAINT [PK_tbPackage_ID] PRIMARY KEY CLUSTERED ( [PRO_PackageID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]


Note that the field PRO_PackageID has an identity, and is a primary key.

Also note the constraints on several fields and the default values.


If I try to move this table and data using the SQL Server Import and Export Wizard, telling it to drop and create the table, and to keep identity, it does not correctly generate the table defintion - it generates the following script

CREATE TABLE [Migration Staging].[dbo].[tbPRO_Package] ([PRO_PackageID] int NOT NULL,[PackageCode] varchar(8) NOT NULL,[LKU_VatRateCode] nchar(10),[CancellationCharge] decimal(18,2),[CancellationMultiplier] decimal(18,2),[CreatedDate] datetime NOT NULL,[CreatedBy] varchar(50) NOT NULL,[ModifiedDate] datetime NOT NULL,[ModifiedBy] varchar(50) NOT NULL,[GUID] uniqueidentifier NOT NULL)

We've lost the identity, the PK,the constraints and the defaults.


If I use the SSIS Transfer SQL Server Objects Task, then the primary key is kept, but the identity is not, nor are the constraints or defaults.

Am I missing something? Is it actually POSSIBLE to accurately move tables between databases?

View 7 Replies View Related

Copy Just The Database Structure Not The Data

Feb 19, 2007

I have been working on my windows app, using SQL Server 2005 (& C#) but I now have loads of junk data, so I want to copy the structure without any data to a new set of files that can become the production version.

I assume I can use backup and restore in future when I want a copy of my production data to use for future testing.

How would I take just one table from my test database and add it to my production database without retyping the design?

Apart from the size limitation is there any advantage in buying a version of SQL Server over using the Express edition?

View 1 Replies View Related

SQL XML :: Copy And Alter Data Into New Database

Sep 17, 2015

I have database1 and database2. Most table names are the same between both dbs.

I would like to copy a column from db1 into db2 but since the data requirement on db2 is different i would like to change it before inserting.

Example:
Data from db1: <SomePage id="1" <template>This is a test </template>

When it saves to db2 it needs to be 
<Page ident="1" <content>This is a test </content>

Is this possible at all? 

View 2 Replies View Related

Copy Database Structure But Not The Data

Feb 13, 2008

I'm looking to create a new version of a database but with completely reloaded data - so I want to retain the database structure but none of the data.

Is there an easy way (read: without a DBA on staff) to copy an existing database structure - preferably with views and stored procedures - and not take the data along for the ride?

Thanks in advance for suggestions...!

View 7 Replies View Related

How To Copy Data From Sqlexpress 2005 Database?

Jan 30, 2008

 Hello everyone. i am using vwd 2005 express edition along with sqlexpress 2005. if i need to use database in my project. i click on database explorer and  create a new table from the existing database. it is working very fine. But my problem is when ever i copy the project in my pen driveand try to use in another computer,  the database doesnot gets copied when i copy my project folder. well i also tried to copy the tables from the database explorer but it does not happen.i tried to locate where does the database get stored in my computer.but i cant find where it resides..and even if i find which file to copy?i think there is log file and database file in some cases. can some body clarify me this scenario here.just tell me where can i find my database i m using in my project,so that i can copy it .  and also whats the use of creating .mdf file in  the project.?is this the better way of using database rather than creating using database explorer?confused?? thanks.jack..  

View 10 Replies View Related

How To Copy Database Structure From One Db To Another W/o Affecting Data

Jul 23, 2005

Is there a way to copy the structure from one database to anotherwithout affecting the actual data?For example, I added new fields and stored procedures to a db in mydevelopment environment. There are a lot of them.I now want to make the same changes to my production environment db butdon't want to affect the data. Only the fields, stored procs &constraints and stuff pertaining to the structure of the db should bechanged.Does anyone know of a program that can do this or can this be done inMS SQL Enterprise Manager.Any help would be appreciated.7078895

View 2 Replies View Related

Best Way To Create A Remote Database And Data Within It?

Apr 26, 2005

Is there any tool that will allow me to create a script for creating a database with all its objects like triggers, indexes, relationships etc. and also populating the tables with data ? So far I haven't found any.

View 1 Replies View Related

How To Copy Tables And Its Data With Procedures Etc To Another Database In MS Sql 2005

May 29, 2006

i want  to copy some tables from 1 database to another with its data & procedures etc to another database in Microsoft SQL 2005.
can any one help
plz reply
tnx alot

View 5 Replies View Related

How To Sync PDA Data (in XML Format)with Remote Database (SQL)

Mar 30, 2004

hello everyone,
i am developing a application using C#and .NEt compact framework.
for that i need to sync pda data (in xml format) with the remote database server(SQL) and vice versa.
please help me out
thanks in advance.

View 5 Replies View Related

How Do I Copy The Index Statistics To A Development Database Server Without Data.

Jul 16, 2007



I want to be able to reproduce my production execution plans on development with copying data.

View 1 Replies View Related

Copy Raw Data From A Flat File To A Database Table, BUT Do Not Insert Duplicates

Aug 2, 2007

Hi,

I'm new to SQL Server 2005 SSIS. I'm trying to do something very simple, but I cannot figure it out, PLEASE HELP!

I have a flat file, which I read and then insert the data in a database table, that works fine. The problem is that I don't want to insert duplicate records. For example; if I run the package again, it will appent to the table. What I need to do is that if the package runs again, check if the record already exist, based one two columns, date and hour, and do not insert the record.

Thank you,

Aldo

View 1 Replies View Related

Copy View And User Defined Functions To Another Database Without Replacing Data

Mar 5, 2008

I work on a copy of SQL Server Express on my desktop. After modifying and creating views and user defined functions, I would like to copy and paste them into the working database. Is there a method programmatically of doing this or must I copy and paste the t-sql language from the existing view to the new database--then save the new view on the working database?

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved