Best Way To Move Data

Jun 7, 2007

Hi,

I'm a C# developer, not a DBA, but fairly familiar with sql server 2000 and learning 2005. I have a need to update a table on one sql server from another remote sql 2005 server. Both will be SQL 2005, but will not be on the same network, so there will be firewall issues to contend with. Security is not a huge concern as the data is public info and not personal secure information or anything like that. What I'll have is a table of data in one sql database. I will have a copy of that data on another sql server that is used at an ISP and drives a web site. I need the table at the ISP sql server to get updated from the SQL server that is onsite in our office on our private network. I would like to not have to get network admins to open sql server ports if possible, so I guess I'm wondering if there is an easy way with SQL 2005 to update data from one sql server to another in the environment that I have described that maybe could expose the data over a common port (ie port 80). I don't want to have to use integrated security as I'm not sure this would work between remote databases in this scenario. I don't know if the web service end point support in sql 2005 would allow this. The examples I have seen online show a sql endpoint created and then accessed from a .NET application. I can do that if I have to, but I would rather do all of this inside the database in some fashion. I am open to any idea that would work and if I need to, I can ditch the idea of using something over port 80 and can get the necessary ports open between the sql servers. This is a pretty simple scenario that we have with one table of data needing to be updated weekly on a web based sql server from a remote sql server.

Any ideas on how you would approach this would be greatly appreciated. Security for the data I'm accessing is not a huge concern as the data is public domain as I've said, but I need to make sure the rest of the server and database on both ends are secured.

Thanks for any help!

View 6 Replies


ADVERTISEMENT

Reporting Services :: Print Data With Blank Space And Move To Continue Data To Next Page

May 15, 2015

I am using SQL Server report 2008/2012 (SSRS) and my report viewer contains body content with 3 Row groups.
While printing the report,  data print with blank space and move to continue data to next page. 

Departure flight : 70 rows
First Page            : 42 rows printed
Second Page      : 23  rows printed  [ Supposed to be print 28 ,  if the total count of records more than 23 and less than 42 then the page print only 23 records ]
Third Page           : 5 rows printed

Departure flight : 42  rows
First Page            : 42  rows printed [Report max. record allowed to print 42 rows so if total record is 42 then print perfectly ]

Departure flight : 26 rows
First Page            : 23 rows printed [Supposed to be print 26, if the total count of records more than 23 and less than 42 then the page print only 23 records ]
Second Page      : 3 rows printed

View 3 Replies View Related

Move Text Data (not A File) Into An Image Data Type

Mar 11, 2008



The ERP manufacturer used an image data type to store large text data fields. I am trying to move these data types from one database to another database using either Sql Queries or MS Access. I can cast them as an 8000 char varchar to read them directly but have no luck importing into these image data fields.

Access and Crystal are not able to read these fields directly.

Any suggestions? Most information about these fields has to do with loading files but I am just moving data.

Thanks,

Ray

View 1 Replies View Related

Move Data To New SAN

Jun 14, 2006

Next month client is moving servers to new location. The servers will get new ip and subnet Our user db's which are on a SAN will be moving to new SAN. My plan is the following, please correct any mistakes.

1. Do full backups of everything
2. Detach user db's
3. Copy these files to usb box (100 gig worth)
4. After server is in new world bring it up
5. Copy db files from usb
6. Attach db files

View 6 Replies View Related

What Is The Best Way To Move Data From...

Jul 20, 2005

Am MS Access 2000 DB To an SQL SERVER 2000?(without Enterprise manager)

View 3 Replies View Related

Move Data Between Databases

May 18, 2008

hi, I currently uses SQL Server 2005.I need to move the data to my website, how do I do that? I have the SQL Server Management Studio Express but I couldn't not get it to export the data in .sql file (which is needed to import to my website's SQL database).Please let me know of any tools I need to perform the task. thanks. 

View 3 Replies View Related

Move Data Between Database

May 15, 2006

Currently we update database A everyday with tables from database B.
Database is India and has poor connection speed. What would be the best method of moving this data.
Currently it's about 100 tables and on average its about 900 mb.
Any input is greatly appreciated.
thanks,

View 3 Replies View Related

How To Move Data Fast

Jan 23, 2004

Hello everybody
We need to move table T1 from database A to T1 database B on same server

size of table T1 15 GB and 40000000 rows

database B just created and will act as warehouse

could it be done simply by
1.creating table T1 on db B and then
2.set db to simple recovery
3.
insert into B.dbo.T1
select * from A.dbo.T1
4. create all the indexes on table T1 in db B

free disk space is 35GB

Any idea how to optimze import
Thank you

View 5 Replies View Related

Move All, But Data, From One Sql Server To Another

Feb 23, 2007

Guys,

We are currently moving our environment. I was told that we need to copy all the stuff over. More specifically, we want to move everything except the data, as our data is dynamic and will fill up in a few days by itself.

What is the best way to move everything over from one server instance to another?

My current approach is the following:

1. Create the file groups we have on our current server on the new server
2. Script out all databases with stored procedures, functions, views, priviliges, indexes ...
3. Script out all the jobs
4. Script out all the dts packages (or rather save each in a file)
5. Load all scripts into the new sql server
6. Re-create user accounts (can these be scripted out also and then loaded?)


Am I missing something or is there a wiser alternative?

Thanks a lot

View 3 Replies View Related

Move SQL 2000 Data To SQL 7

Mar 12, 2004

We have a problem with our SQL 2000 server which we know is a product bug.

Is there anyway of importing, Copying the sql 2000 table back down to SQL 7 until the issue is resolved,

many thanks

View 1 Replies View Related

How To Move Data Files

Jul 20, 2005

hello,my problem is how to move data files drom drive c: to drive d: ??--MarcinS

View 1 Replies View Related

Move Data From Sybase

Apr 23, 2008

I need to move data from Sybase ASE to SQL Server 2005. What is the best way fo doing it?

View 1 Replies View Related

Move Data From One Database To Another

Nov 12, 2007

I have two databases DB_1 and DB_2 on my server. Both of them have 25 identical tables.

Tables under DB_2 gets refreshed with new data daily and once it's ready with new data, those data should be copied to DB_1 tables (deleting any existing data and loading it with new data).

My question is there any other way other than using Import Data Wizard for moving the data between two databases which included deleting any existing data on DB_1 tables and loadit with new data.

Please let me know...Thanx in advance...

View 7 Replies View Related

How Can I Move My Production Data Only To My Dev Env.

Sep 14, 2007

I'd like to move data from my prod. env. to my dev. env. The data in dev would be replaced by the prod one. I cannot do a detach/attach or backup and restore due to some already existing dev objects located in the dev. env.

Any lead on how I can do this?

Thanks Marcel

View 5 Replies View Related

How Do I Move Data From One Database To Another?

May 8, 2007

I have two databases located on the same server. I was able to script a identical table in the other database, but how do I transfer the table data there?

View 5 Replies View Related

How Do You Move Data From One Table To Another?

Apr 2, 2008

I don't know what to do here please help! I have 2 tables here and I want to move selected data in one table to another but im not sure how to do it.

Thanks in advance =)

View 4 Replies View Related

Move Data From SqlDataSource To A TextBox

Apr 9, 2007

I have a DataReader on a web page: <asp:SqlDataSource ID="ChangeInfoRecord" runat="server" ConnectionString..........
I want to display the value of one of the returned field in a text box.  What is the correct syntax?  I tried
RolledFromDisplay.Text = ChangeInfoRecord("RolledFrom")
but that isn't it.

View 1 Replies View Related

Move Data From DataBase1 To Database2

Aug 25, 2005

Using Stored Procedure ~ I'm trying to get data from Database1 into Database2
from the column name (ManufacturerID).

Column Names are the Same in both Databases :e.g. Database#1(Empire1.dbo.Location.ManufacturerID) e.g. Database#2(Empire2.dbo.Products.ManufacturerID)Heres what I've tried but is throwing me an error...SELECT ManufacturerID INTO Empire2FROM Empire1.dbo.ProductsINSERT INTO Location.ManufacturerID

View 14 Replies View Related

Need To Move Data And Log Files To A Different Drive?

Jul 3, 2001

View 1 Replies View Related

Move Data From One Column To Another In Same Table

Sep 12, 2004

Okay, after I got everything imported, I found that a few thousand columns had "Shifted" on me. So now I am trying to "Shift them over" to where they need to be.

I did this:
INSERT INTO dbo.TABLENAME (COLUMN_NAME_TO_BE POPULATED)
SELECT COLUM_NAME_OF_INFO_TO_BE_MOVED
FROM dbo.TABLENAME
WHERE MFG = 'MANUFACTURER_NAME' AND PN LIKE '8888888888'
GO

I populated the PN column with 8888888888 to use as a reference point, and the MFG column already was populated with the correct name, so I was using those as my unique reference points.

Other columns that have the same MFG name are correct, so I have to use two unique identifiers to specify the actual data that needs to be moved.

It inserted 'NULL' in the whole table after I ran it in the Query Analyzer. It appeared to disregard the WHERE statement all together
Any ideas on what I am doing wrong here?

Is there a way to move the data from one column to the next one over by specifying other WHERE criterias?

View 1 Replies View Related

Using DTS To Move Data From Oracle To Access

Apr 7, 2004

I'm attempting to move data from an Oracle table to an Access table using an Oracle stored procedure in DTS. The problem is that you can't pass parameters to an Oracle stored proc when its called in a data pump task. Is there a way to pass global variables into an Oracle stored procedure which retrieves data and moves it to an Access database? Maybe in an Active X task? We are required to use an Oracle stored procedure by our DBA's or else I'd just pass the variables into a SQL string and use it in the data pump task.

View 1 Replies View Related

How To Move Duplicate Data Into Other Table

Dec 10, 2013

We need to move duplicate data from this sheet to other table also having issue that sometime verifiedmemberID is null as well as verifiermember name is null and also having the values in BCP authorisationcode as well as FPoveridecode but transactionmode/bcpmode is 'n' and also having condition that transactionmode/bcpmode is 'y' but bcpauthorisationcode is blank.

MemberStatecodeMemberDistrictCodeURNCompanyCodeHeadMemberIDHeadMemberNamePatientID
PatientNamePatientGenderPatientAgeTerminalIDHospitalCodeRegistrationNoBlockingUserDateUnblocking
InvoiceNoDischargeInvoiceNoDischargeDescDischargeUserDateAmoutClaimedTransactionMode/BCPMode
UnspecifiedAuthCodeUnspecifiedAuthDateBCPAuthorizationCodeBCPAuthorizationDateFPOverideCode

[code]....

View 2 Replies View Related

How To Move Data From ColumnA To Another ColumnB ?

Aug 28, 2006

Table :
ColumnA ColumnB
ABCDEFGH
12345678
11223344X
55667788ZZ
7788221
223
6667
I want to move 4 character from third position in ColumnA to ColumnB

ColumnA ColumnB
ABCDEFGH-------CDEF
12345678-------3456
11223344X------2233
55667788ZZ-----6677
7788221--------8822
223------------3
6667-----------67

How can i do ?
Thank you very much !

View 7 Replies View Related

Can I Move To A Secondary Data File

Jun 22, 2007

I have a database that has been running well for a few years.
It has a single data file.
It has now become very large and is creaking and running slow sometimes.
Is it possible to now create a secondary data file or do i have other options?
Many Thanks

View 4 Replies View Related

Needed Query To Move Data....

Feb 7, 2008

Hi Guys,
I am having a table in a database.....and i need to write a query to move tht table to microsoft access.......
so is tht possible with a query???

Thanks

View 6 Replies View Related

Failing To Move Object And Data

Mar 11, 2008

Hi All

Just created replication from sql server 2005 (Discributor and Publisher) on the same server and my subscriber is sql2000 database.

Everything was created successfully but on the sql 200 DB I only see MSreplication_subscription,Mssubscription_agent and Mssubscription_properties.

all the bcp file are in a shared folder.

I've been checking I cann't see what could be the problem

View 5 Replies View Related

Using DTS To Move Data To A New Table With Some Datatype Changes

Jul 23, 2005

I have a production application that I am building some upgrades usinga second (empty) copy the database. A few of the upgrades includedchanging the datatypes of a few fields from varchar to int(all thevalues in this column are already numbers)I am not trying to move the data from the production database into theblank database using DTS and the fields that had their datatypeschanged are getting dropped by dts.Is there anyway to move this data easily through dts or through anothermethod and not have the fields with the datatype changes get dropped?I have about 60 tables so it is not as simple as just copying andpasting the data..

View 2 Replies View Related

Move Data Between Datafile In Same Filegroup

Jan 28, 2008



Hi all

I've found this problem working with a VLDB, six month ago when I install the DBMS (Win2k3 x64+sp2, SQL 2k5 x64 +sp2, 4 dual core processor and 12 GbRAM) I've got 10 disk (actually ten LUN from a Storage Area Network), each 50Gb.
I've put TempDB and Transaction Log on two separate 50 Gb disk and put the database on 8 different data file on the 8 disk; I've created each datafile with a size of 50 Gb (autogrowth disable), so my DB has 400Gb space in it's datafile.
After a while the datafile began to fill and we decide to add a couple more 50Gb disk where I decide to put to new datafile; now my db is around 430 Gb and I've got this strange situation:


The first 8 datafile now are almost full of data, and obviously they can't growth since they already occupy the whole disk.

The two additional datafile are relatively empty (about 15 Gb each).

As far as I understand now each time that SQL should write to the databse it writes only on the 2 new datafile, and I fear that this can affect performance.
I'd like to reorganize the space in order to have 10 datafile, each with 43Gb of data, but I didn't find any instruction/tool able to move data between datafile.

Anyone has any hint ?

Thank you in advance for any suggestion
Stefano


View 5 Replies View Related

Move Files In Data Flow

Sep 7, 2007



Hi all,

I'm trying to find some way to implement a move file task in my Data Flow. I parse through a flat file, retrieve a value, then I'm using a lookup table to check if that value exists in a table... if the value doesnt exist, I need to move this file to a new directory and insert the value into a different table. Does anyone have any ideas about how to move the file while using the Data Flow pane?

Or is there some way to pass information from the look up table to the Control flow pane and use the Move File Task there? I'm trying to stay away from a Script task or a Script component unless it's unavoidable. I appreciate any ideas!

View 6 Replies View Related

New Install, But I Need To Move Data Files

Apr 26, 2007

I could really use some help on this one. I know virtually nothing about SQL Server. We installed this because our database for the application we're running (Lexis Nexis Time Matters) had gotten too large for the Express 2005 version. We've also installed a new version of the software, and on a new server.

The new server has the drive partitioned into two partitions. When installing the application, I selected drive D (545 gb) as the data drive, but when I installed SQL server, it was installed on drive C (12 gb). I did not realize that the the application data was simply configuration information, and the data for the program is actually being installed on the C drive (Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData).

Is there a simple procedure to move this data, including the SQL instance (TIMEMATTERS) to the D drive? Or should I uninstall and start over?

View 1 Replies View Related

Move Data To DB2 On AS400 With SSIS

Dec 26, 2006

Anyone writing data to DB2 on an AS400 with SSIS?

I cannot get the OLEDB destination configured correctly. I can set the destination up with a SELECT sql query, and preview the resultset.

View 38 Replies View Related

How To Move MSDE SQL Data To SQL Express

Nov 30, 2006

I have a 3 workstation peer to peer network with everything running Windows XP Pro. I need to replace the machine that hosts my SQL MSDE server. I have built a new system and all software is installed except the MSDE. I use a proprietary product called Time Matters for my law practice that uses the SQL server. Since I might want to run Vista eventually (not right now) I thought that I would try to migrate the MSDE to SQL Express. I assume that Time Matters will run on SQL Express. Can someone please give me some help on how to proceed. I'm thinking that I will install the SQL Express server on the new machine and then somehow migrate the database over to the new machine and shut down the old unit. Any help would be greatly appreciated.



View 1 Replies View Related

Best Approach To Move Data On A Same Server

Nov 26, 2007

I have staged my tables in a database which is in the same server as the destination database and they are on sql server 2005.

Now I need to push the data from the staged table to destination.


Which is the best approach in ssis ?


1) using execute sql task to a call stored procedure to push the data to a different database using server.dbo.table name from the stored procedure.


or


2) using dataflows to call a stored procedure and map source and destination.

View 13 Replies View Related







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