Transfering Data From One Machine To Another.....

Sep 6, 2003

Hello all

I have a SQL Server 2000 database in a remote host and I want to move all my data to another remote (virtual) host, where on both machines I do not have direct access.

Can you advise me what is the best way to make this transition?

Thank You in advance

Nick

View 1 Replies


ADVERTISEMENT

Select Data From 2000 Machine From A 2005 Machine

Jan 17, 2008

Hi,

here goes the question:

i have 1 sqlserver 2k5 machine (machine A) and sqlserver 2k (machine b)

how do i build a query to select data from 2k machine in a query of 2k5?

i mean something like

select *
from login:passw@machineb.dabatase.dbo.customers

thanks!

View 2 Replies View Related

Select Data From 2000 Machine From A 2005 Machine

Jan 17, 2008



Hi,

here goes the question:

i have 1 sqlserver 2k5 machine (machine A) and sqlserver 2k (machine b)

how do i build a query to select data from 2k machine in a query of 2k5?

i mean something like

select *
from loginassw@machineb.dabatase.dbo.customers

thanks!

View 6 Replies View Related

Transfering Sql Data Into Csv File

Jul 20, 2006

Is there any way the i can write query in sql statment and transfer the result set into csv file with header info and one row option.
 
Thanks,

View 1 Replies View Related

Transfering Data From DB2 To SQL Server

Jun 27, 2000

I've read about using starsql odbc and sql server 7.0 DTS utility to transfer the database or data from a DB2 to SQL Server.
I have a SQL Server 6.5 and need to transfer data from a DB2. Is the operation the same? Is there a utility in sql server 6.5 that allows this?

View 1 Replies View Related

Transfering Data Between Tables At Different DB's

Dec 27, 2007

HELLO.


I have two similar tables at different databases. Their ID columns are same. I want to update one of them like:


Table A
ID Name


Table B
ID Name


UPDATE DB1.dbo.TableA SET Name = (SELECT Name FROM @DB2.dbo.TableB)...


I have problem with WHERE clauses. Can't figure it out. Can you help me?


Thanks in advance.

View 1 Replies View Related

Transfering Data To SQL Express

Apr 24, 2008

I have a database that I have created and I would like to transfer it to an Sql Express instance I am not sure how to do it... Can anyone help?

View 1 Replies View Related

Need Help Transfering Data From A Texfile To A SQL Table

Nov 29, 2007

 Hello all,I am currently working on upgrading the old website to an asp.net website.Current website uses flat-files as its database, so I need to convert a few files into SQL tables.The file that I am having difficulties with has the following structure (tab and coma separated):OrderID    CustomerID    ItemNO1            1                    1,2,3,42            1                    5,6,73            1                    4,5,67,4576A,234            2                    4,56,678,DF23,75            2                    78,2,567,4556,3,45,FG456            3                    2,45, F35 etc.... and I need my table to be structured like this: OrderID    CustomerID    ItemNO1            1                        11            1                        21            1                        3 1            1                        42            1                        52            1                         62            1                        7.......................The import function in SQL database will not do this. Is it possible to automate this somehow? Thanks 

View 4 Replies View Related

Date Format In Transfering Data In DTS

Aug 24, 2000

Dear all DBA,

i really need some help from all of you.
I currently have some DTS package which will transfer data from
text file to the SQL 7.0
This transformation is schedule using the Sql Agent.

The problem is the transfering data which have the Date datatype.
the Date format is in the dd/mm/yyyy. But the default language i set in my
sql server is english which suppose will use the date format mm/dd/yyyy.

therefore, the Sql server will treat my data which in dd/mm/yyyy as mm/dd/yyyy. so, the data like '08/09/2000' (in dd/mm/yyyy) become '08/09/2000'
(in mm/dd/yyyy)

i already set my user'language who will login in the sql agent as 'british english'. I also the OLE connection in the DTS package that i built using 'british english'.

when i run the agent in the Sql Enterprice Manager, it use the dd/mm/yyyy format which is correct. BUt when i log out and let it run as services which mean let the agent excute the DTS. it use back the mm/dd/yyyy fromat which cause the data become wrongs.

i hope someone can give me some advice on this.
Thanks for your help

from
samuel yeong

View 1 Replies View Related

Transfering Data From Informix To Sql Server

Feb 6, 2004

I need to transfer seven tables from Informix DB to SQL Server every night. Any suggestions for the best way of doing it? Is DTS the best way? How about through replication?

Thanks in advance.

View 1 Replies View Related

Transfering Data From DB2 OS/390 To SQL Server 2005

Aug 3, 2006

How can I make a connection in SSIS Data Flow to connect to DB2 on the mainfrain? Have several DTS packages in SQL Server 2000 that uses the ODBC connection.

Please help!

View 3 Replies View Related

Transfering Data From A Web Form Into Sql Server Database

Sep 20, 2005

Hi I am trying to develop a web based application. I am trying to insert data from my web form into sql server database using stored procedures. I am having a problem while i try to exceute the command. The error given by system is System.InvalidCastException: Object must implement IConvertible. at System.Data.SqlClient.SqlCommand.ExecuteNonQueryany suggestion what am i missing?With Regards,Sameer Jindal

View 2 Replies View Related

How To Select A Different Member Name When Transfering Data From AS400 To SQL

Apr 4, 2007

I have been trying to transfer some data from a file located in a AS400 Server to SQL , but the file has more than one Member Name. I'm not sure how to specify a different member name on the SQL query . Please help.



The name of the file is:

Library = MTGLIBP2

File Name = CHSAVQPL

Member Name = INS



this is the query I have so far but I still need to reference the Member Name



SELECT *
FROM OPENQUERY(AS400PL,'SELECT * FROM mtglibp2.CHSAVQPL')

View 1 Replies View Related

Which Method Is Better For Transfering Data Using Direct Inserts/SSIS?

Feb 7, 2007

Hi

I'm transfering legecy data to SQL Server.

Can anybody tell which method is best.

My boss wants cutome user interface to choose options and Need to update UI during processing.

Currently I'm using Direct INSERT Stmt (T-sql) Execution.

Can Anybody suggest the best.

View 1 Replies View Related

Problem In Transfering Of Tables Data From Lotus Notes Db To SQL Db

May 29, 2008

Here is the different problem which is irretating me alot from last 2 weeks. Could any body suggest on this problem?

I am using the ADO.net providerODBC provider connection for Data Reader source. I don't know why the total records are not populating from source(lotun notes db) to Destination (SQL server 2005). The package is populating only 2000 records out of 10000 records. Please suggest me how to fix this problem. There is no error message is coming for this problem

View 8 Replies View Related

Transfering Tables And Data From Oracle To Sql Server 2005

Nov 15, 2006

I have a oracle database that creates a table (to store call records) everyday and places data into it. How can i use Interation services to transfer the newly created tables to an SQL server database (SQL server 2005).

View 4 Replies View Related

Transfering Data From SQL Server Standard To SQL Server Express

Feb 28, 2008

Hello folks,Are there any tools that can transfer database and it's content fromSQL Server Standard version to SQL Server Express database?I tried to backup database in SQL Server Standard and then restore itinto SQL Server Express but it didn't work. Are there any tools thatcan extract SQL clauses to create database, tablesand data inserts into file? Or any other method to transfer database/data from SQL Server Standard to SQL Server Express?Cheers,

View 1 Replies View Related

Ssis Package Hangs On Script Transformation When Running On One Machine Not Developing Machine

May 4, 2007

Help!
I am using Script Transformation to output a new column as image[DT_IMAGE]
field to store serialized object. In the VB script, the sample code as

Row.serializedobject.AddBlobData ( binaryArrayReturnedFromC#dll )

The package always runs fine on my developing machine and will halt on other
machine at AddBlobData after certain number row records were processed. I am
stuck here. Anyone has any suggestion?

What I need is reading data from mutiple tables in one database and writing
into a single table in another datable. In order preserve all the columns
data, I use input column fields to construct a new object and then serialize
it, and store the serialize data into detination db table. (The object and
serialization function is coming from c# dll.)

Dim b As BusinessLicense = New BusinessLicense()
b.ApprovalDate = Row.approvaldate
b.BusinessId = Row.busid
b.BusinessName = Row.busname
b.NaicsCode = Row.naicscode
b.NaicsDescription = Row.naicsdescr
b.OwnerName = Row.ownername
b.Phone = Row.phone
b.Pkey = Row.pkey
b.RenewalDate = Row.renewaldate
b.StartDate = Row.startdate
b.Suite = Row.suite

Row.serializedobject.AddBlobData(Serializer.Serialize(b)) '''----This is blocking line
Row.infoType = BusinessLicense.TYPE



Both machine is xp with sp2. and standard SQL Server 2005 - 9.00.1399.06

Thanks!

View 4 Replies View Related

Transfering Data From One Table To Another Table

Aug 16, 2007

If we are transfering data from one table to another table say for ex transfering 1000 rows from one table to another table, how we can find whether all the rows are transfered.

View 6 Replies View Related

SQL 2005 Enterprise Edition The Image File Setup.exe Is Valid, But Is For A Machine Type Other Than The Current Machine

Nov 28, 2006

Hi All,

I have enterprise version software CD1 and CD2 of SQL server 2005

when i try to run setup.exe..the following error pops -up

The image file Setup.exe is valid, but is for a machine type other than the current machine

MY OS version is windows 2003 32bit Operating system...

I am suspecting the binarie may be of 64bit.. How do we check the binaries are 32 bit and 64 bit software

Thanks for your Help

Mohan



View 4 Replies View Related

Connection Pool Leak In Production Machine (in Other Machine It Runs Well)

Nov 16, 2006

Hi to everyone,
I'm facing a problem that drives me crazy. I've a web application that has the following problem. When I test the application on my developement machine all runs fine, but when I put into production server there is a problem in connection pooling. Look at the following image, the blue line is the number of connection in the pool and the violet line is the number of connection reclaimed. From the image it is clear that connection are returned on the pool only in block, maybe when the garbage collection pass and reclaim the object. The strange thing is that on my developement machine all is good, and also I'm using Enterprise Library and the connection are managed internally.- Thanks to everyone for any help.   

View 2 Replies View Related

Running A Stored Proc On A Standalone Machine From Another Machine In A Domain

Oct 2, 2000

Hullo all
I have two machines,
One is a standalone machine and the other is on a domain network. How can I run a stored procedure/job on the standalone machine from the domain machine ?
running the procedure as a Domain user results in a failed job/stored proc.
also creating an sql login and attempting to run it as that user also fails. How can I solve this problem ?
please e-mail me at wayde@sunnygrp.com if you have any thoughts...

View 1 Replies View Related

Copying Database From 2000Server Machine To 2003 Server Machine

Jul 23, 2005

Hi All;We are going to change our application server. We will copy all of ourDatabase from Mic 2000 Server OS to Mic 2003 Server OS. I found anarticle that how to move all the folders from same OS. My question isthat Would the 2003 OS be a problem when we copy all of the MC SQL 2000folders to New OS ? Has anybody done this before? Could you gimme yoursuggestions please?ThanksASA

View 1 Replies View Related

How To Get Data From MS SQL Server From Linux Machine?

Mar 10, 2004

hi all,

I need to collect data from 60 SQL Server into one big DB2 server using mulit threaded C program under linux, just wonder if anyone have tried to make a program under linux to get data from MS SQL Server under windows.

i need to code in C under linux, connect to SQL server and also connect to DB2 server


what i understand so far we need on clinet side (linux machine)

1. ODBC software ( there is open source unixODBC )

2. MS SQL Deiver under linux ( i checked softlink )

does anyone has experince in such stuff ?

i need a start point

any suggestions ?

View 1 Replies View Related

How To Migrate Data From A Server To A New Machine

Feb 19, 2007

Hi to all,

I m a new DBA
I have a problem
I have a SQL Server with 300 Databases on a machine.
Now company has bought new Machine
How to migrate data from old server to this new machine
without recreating logins
can some one help

Thanks in advance

View 4 Replies View Related

Data File In A Different Machine On The Network.

Jul 20, 2005

Hi All,I have a requirement to create the database with data and log files ina different machine on the network.Googling, I got a link which said Mapped drives do not work but UNC pathswork. However in my case, both are failing.Any advices or links on net will be highly useful.Thanks and Regards,Chandra Mohan

View 5 Replies View Related

Back Upwith Out Any Machine Specific Data

Jun 25, 2007

 





How can i take back up of a data base
with out having any machine/system specific
data in the .bak file?

View 5 Replies View Related

How To Rebuild SQL Server Machine Without Any Data Loss

Mar 26, 1999

We wanted to rebuild our main SQL server machine. How can we backup everything about the SQL server (such as all databases/objects and settings on security and users) and then recover them without any data loss?
A related question is how to recover the server machine in case of system failure or whole machine crash down?
Thanks!

View 1 Replies View Related

Back Upwith Out Any Machine Specific Data

Jun 25, 2007

How can i take back up of a data base
with out having any machine/system specific
data in the .bak file?

View 7 Replies View Related

Back Upwith Out Any Machine Specific Data

Jun 25, 2007

How can i take back up of a data base
with out having any machine/system specific
data in the .bak file?

View 5 Replies View Related

GetDate() - From Server Machine Or Client Machine ?

Oct 23, 2006

Hi,

If I use GetDate() function from client machine (using "\ServerMachineSQLExpress" instance from client machine "ClientMachine"), then from where I will get the DateTime value ?

From "ServerMachine" or from "ClientMachine"

Thanks

View 3 Replies View Related

Migrating SQL 2005 Test Machine To New Machine

Jul 13, 2007

Hi Guys,

I was wondering if there was any white papers on the migration part from microsoft?
Apparently the situation is like this
Currently installed MOSS 2007 in a testing pc as application server. This application server will refer another testing database server which running SQL Server 2005.

Now, wanted to move this 2 temporary server into another 2 new servers.
Correct me if I'm wrong, it cannot be done by using image like Norton Ghost due to difference hardware spec.

So, if I install another fresh copy of MOSS2007 & SQL server 2005 in that 2 new servers, how can I migrate the contents, documents, etc from the testing database server?

It would be great if someone can show me the links to kb article. Thanks

View 1 Replies View Related

Report Manager On 64 Bit Machine Does Not Recognize 32 Bit Data Sources

Aug 22, 2007

I'm a report developer who has created some reportsd against sybase data on another server. I am developing on a 64 bit Server 2003 box using SQL 2005 Reporting services. I hace created 32 bit ODBC data dsns using the supplied utitlity (odbcad32.exe). As I am creating the reports I can pull data using the data sources without a problem, however when I deploy my datasource and report to Report manager and run I get the following:


An error has occurred during report processing.

Cannot create a connection to data source 'Chicago_Reporting'.


ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified






This has been driving me crazy for 2 days now. Any help would be very much appreciated.

Thanks

































View 2 Replies View Related







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