SQL Transfer From Alpha To Intel Platform
Oct 19, 2000
please please help?
For the last couple of days i've been trying to transfer a SQL6.5 database from an Alpha platform to an Intel one.
At one point i loaded SQL7 on the Intel platform and tried to perform an upgrade (using the wizard), across the network - but it just did not want to play.
Using Veritas Backup Exec, with SQL6.5 on both machines, i've tried doing a backup of the database on the Alpha platform and then restore to the Intel Platform, but this fails stating that the processors are incompatible
Am i trying something that is impossible?
If anyone could point me in the right direction i'd be truely grateful.
Sharpy
View 1 Replies
ADVERTISEMENT
Jan 7, 2002
Hello:
Our company needs to (restore/migrate) our Alpha Nt4sp4 sql 6.5sp5a databases to an Intel hardware platform. For the time being the new intel server will be runing Nt4sp4 sql 6.5 sp5a. I understand that if we were to upgrade to sql 7 we would be able to restore the databases without any problems. However upgrading to sql 7 is not an option right now. I have tried to restore a backup from the alpha to an intel based machine, and it fails because the processor types are different.
I have already search technet, but found nothing, except upgrade to sql 7.
I am hoping someone out there could point me in the right direction.
Thank inadvance for your help, I appreciate it very much.
Cindy
View 1 Replies
View Related
Jun 20, 2000
Hello,
I am looking for ways to migrate Sqlserver 6.5 from Alpha to Intel plat form. The only method I heard was Database/Object transfer.
Is there any other way?
Thanks,
yi
View 2 Replies
View Related
Dec 10, 1999
Hi,
I'm trying to move a database over from an Alpha to an Intel-base PC. The SQL Server database is on an Alpha server. The 2nd machine is an Intel. When I make a backup of the database from Alpha, copy over the file to the 2nd PC (Intel) and then try to restore it from the 2nd PC, it doesn't sure up on the list of restores when I click on 'Add Device'
The only other way I can get this to work successfully is with a Database Object Transfer, which takes too long (several hours) and limits me to being on site. I need to do this every few weeks so I need a better way to transfer the database over ?
Anyone have any experience with SQL Server on Alpha??
Joyce
View 2 Replies
View Related
Aug 18, 2006
Hi,
I was trying to find numeric characters in a field of nvarchar. I looked this up in HELP.
Wildcard
Meaning
%
Any string of zero or more characters.
_
Any single character.
[ ]
Any single character within the specified range (for example, [a-f]) or set (for example, [abcdef]).
Any single character not within the specified range (for example, [^a - f]) or set (for example, [^abcdef]).
Nowhere in the examples below it in Help was it explicitly detailed that a user could do this.
In MS Access the # can be substituted for any numeric character such that I could do a WHERE clause:
WHERE
Gift_Date NOT LIKE "####*"
After looking at the above for the [ ] wildcard, it became clear that I could subsitute [0-9] for #:
WHERE
Gift_Date NOT LIKE '[0-9][0-9][0-9][0-9]%'
using single quotes and the % wildcard instead of Access' double quotes and * wildcard.
Just putting this out there for anybody else that is new to SQL, like me.
Regards,
Patrick Briggs,
Pasadena, CA
View 1 Replies
View Related
Jan 23, 2008
Can SQL 2000 32 bit run on a Windows 2003 64-bit Intel OS installation? What about the SQL 2000 64 bit version? Is the Enterprise Edition required for this?
View 1 Replies
View Related
Jan 19, 2007
Hi
for MS SQL 2000
I am searching users for each letter
WHERE users.name LIKE ('A%')
how can i search For users.name not starting by A to Z ? all except letters
thank you
View 2 Replies
View Related
Jun 14, 2007
Good Morning Db forum.
I am working on a query that I need to pull all fields that contain 3 alpha characters. for example BCB001, MCR001, CHP001 and so forth.
Is there a SQL alpha wildcard that I could use to pull all records that have the three alpha chars?
View 3 Replies
View Related
Oct 14, 2004
hi ,
can anyone tell me if there exists a function in SQL Server that help me determine if a variable is ALL Alphanumeric data or not by returning a 0 or 1 when condition fails or succeeds .
thank you
View 2 Replies
View Related
Dec 23, 1998
Hello,
We want to port our Nt application to Alpha system with Fx!32. Is it possible to have SQl Server on this system.
Is there any SQL server available specifically for Alpha system..? Because there are VB and VC compilers available for Alpha systems.
ThanX
__Vijay VM
View 2 Replies
View Related
Sep 29, 2005
In SQL I need to be able to take a varchar parameter @Area and convert it to a float.
The input values for @Area I can't control. They can range from 6300 to 6,300 SqFt to 1.2 Acres .
So to convert this value to a float I basically look through the string and remove everything that isn't a number or a period. Then I would convert this value to square feet based on how large the number is.
Code:
DECLARE @k int, @Temp VarChar(25), @SqFt Float
SELECT@Temp = @Area
select @Temp
select @k = patindex('%[^0-9. ]%', @Temp)
while @k> 0
begin
select @Temp = replace(@Temp, substring(@Temp, @k, 1), '')
select @k= patindex('%[^0-9. ]%', @Temp)
end
If @Temp = ''
BEGIN
SET @Temp = '0'
END
SELECT @SqFt = Convert(Float, @Temp)
--Distinguish if it was acres or square feet
If (@SqFt > 750.00)
BEGIN
SET @SqFt = @SqFt
END
ELSE
BEGIN
SET @SqFt = (@SqFt * Convert(Float,43560) )
END
SELECT @SqFt
This works great except for one situation, If @Area is something like 6,300 Sq.Ft. . When I run it through the part that removes all non-numeric items and periods, I end up with 6300 .. . So to get around this I want to find the first letter in the string and then remove everything after it. Then take the result and run it through part that removes everything but the numbers and period.
However I can't find away to get the index of the alpha-numeric character and remove everything after it.
Thanks in advance!
View 1 Replies
View Related
Feb 23, 2006
Hi,
How do I do a conditional check for the left most character if it is an alpha or number in a Derived Column Transformation? Something like
ISNUMERIC(newseq) ? "ABC" : "DEF"
Thanks
View 2 Replies
View Related
Nov 9, 2007
We have a table with an indesx that is varchar(7). It contains up to 5 numbers and 2 characters to denote batches. IE. 100a
105zz
1c
2
10001w
In an Access gui I need to be able to sort this field numericaly so each number shows up in its correct position. IE.
1c
2
100a
105zz
10001w
In order to accomplish this, I created a seperate field on the table named Num as varchar(5). I would like to create a trigger that updates this field any time a new batch number is entered. This way I can have my queries order by Num when returning the recordsets to the GUI.
Below is the code that I thought would work, but it is giving me an error near the keyword BEGIN after the IF(ISNUMERIC) statement. I can't seem to find an error with this code, but I thought maybe a thousand fresh sets of eyes could. Any help would be greatly appreciated. Also if you know of a better way to accomplish this task, please feel free to post here.
TIA,
Aaron
CREATE TRIGGER [InsertNum] ON [dbo].[IP_Batch_Table_Temp]
FOR INSERT, UPDATE
AS
DECLARE @Num varchar(7)
DECLARE @Num1 CHAR(7)
DECLARE @x INT
SET @Num = (SELECT IP_Batch_Number FROM inserted)
SET @x = 1
WHILE (@x < len(@Num))
BEGIN
IF (ISNUMERIC( SUBSTRING(@Num, @x, 1) ) )
BEGIN
SET @Num1 = @Num1 + SUBSTRING(@Num, @x, 1)
END
SET @x = @x + 1
END
UPDATE IP_BATCH_TABLE_TEMP SET NUMBER = ltrim(rtrim(@Num1)) WHERE IP_BATCH_NUMBER = @Num
View 5 Replies
View Related
Aug 25, 2007
Hi,
I'm developing an application that will access a database, and then send the data to a server either in batch or as each item is updated over GPRS. The database will have a large table, with 20,000 records. Each record is about 150 characters. The data access needs to be as fast as possible. I'm not sure which platform/hardware to use to achieve maximum speed. I have experience with c#, sql server ce. Worked mostly on Windows Mobile 2003, but thinking of moving to WM 5 or 6. My question is what is the best combination of hardware, OS, development environment, and software to use?
thanks
awni
View 1 Replies
View Related
Jul 27, 2006
If I create an index on a field in SQL Server, what will be the most efficient (fastest) field type to index a field? (This field will be a "Pointer" to a child table that will contain a list of codes, and their description.)
Would a Numeric field be quicker than a VarChar field?
VarChar would make it easier for a Human to decipher the raw records. (For example, if I used a numeric the code would be 42 or 47, while the VarChar could be 'savings' or 'checking'.)
Basically I will have the following "Master" table: FieldType
---------
IDInt
NameVarChar
StatusInt -or- VarChar
Customer_TypeInt -or- VarChar
If Customer_Type is a code that can be looked up in another table, and I index that field, would I want the "Code" to be an Int or VarChar?
SQL: Select *
From Master
Where Customer_Type = <42> or <'savings'>
My Where clause would depend on the field type.
Thank you, Bryan
View 1 Replies
View Related
Feb 28, 2008
HI,
Thanks in advance for taking your time to read this post.
I am trying to write a SQL query using MS SQL 2005 that will read the value of a field and tell if it is alpha or numeric. I have tried the following but it does not work:
select field1 from table1 where left(field1,2)='[0-9]'
select field1 from table1 where isnumber(left(field1,2) tried with a =1 at the end and without and =1 at the end
the goal is to read through a field and format it so if a field looks like this 12xxx111xx I can change it to look like 12-xxx-111-xx.
Any help is greatly apprecaited
View 4 Replies
View Related
Dec 6, 2006
Hi I am trying to strip out any non-alpha characters from a field.
i.e. Field = ABC"_IT8*$ should return: ABCIT8
I am writing a loop to do this for all values of a field. The script runs, but hangs....please could somebody advise on the code below...:
I run the script but it doesn't seem to finish. Can anybody see any issues with the code:
DECLARE @Index SMALLINT,
@MATCH_Supplier_name varchar(500),
@Counter numeric,
@Max numeric
-- @sqlstring varchar(500)
SET @Counter = 1
SET @Max = (SELECT Max(DTect_Supplier_SRN) FROM SUPPLIER_TABLE_TEST)
WHILE @Counter <@Max
BEGIN
SET @MATCH_Supplier_name = (SELECT Match_Supplier_Name FROM SUPPLIER_TABLE_TEST WHERE @Counter = DTect_Supplier_SRN)
SET @Index = LEN(@MATCH_Supplier_name)
WHILE @Index > = 1
SET @MATCH_Supplier_name = CASE
WHEN SUBSTRING(@MATCH_Supplier_name, @Index, 1) LIKE '[a-zA-Z]' TH EN SUBSTRING(@MATCH_Supplier_name, @Index, 1)
WHEN SUBSTRING(@MATCH_Supplier_name, @Index, 1) LIKE '[0-9]' THEN SUBSTRING(@MATCH_Supplier_name, @Index, 1)
ELSE ''
END + @MATCH_Supplier_name
SET @Index = @Index - 1
--PRINT @MATCH_Supplier_name
SET @Counter = @Counter + 1
END
View 2 Replies
View Related
Mar 12, 2004
I need some feedback to bolster my position with a client who is planning a platform migration. They are currently running SQL 7.0 SP3 on Windows NT4 and want to upgrade to Windows 2003. First off, SQL 7.0 isn't going to run on Windows 2003, so their first response is "let's buy the licenses and run Win2000 and SQL7 until we're ready to migrate to SQL2000". Ok... licensing cost controls aside, they're investing significant $$ in acquiring the hardware. What's my most compelling argument for moving them to a Win2003/SQL2000 platform now. (Other than the wait for Yukon is likely to be significant ;-) )
Any feedback would be appreciated.
View 5 Replies
View Related
Jul 20, 2005
Hi,I'm planning to purchase Sql Server2000 St. Edt. and install it onwindows 2000 server machine. I would like to know please if it isadvisable to work on the same machine that host both servers or shouldI work on a separate one???MTIA,Grawsha
View 1 Replies
View Related
Apr 3, 2008
I'd like to integrate SQL CE 3.5 into a platform builder image(using PB 5 targeting CE 5), but I don't see it in the catalog. Is it currently possible to Sysgen an image with 3.5? Can I somehow deploy the files from the .cab files? Sorry if this has been answered before, I searched around a bit but didn't find anything.
View 6 Replies
View Related
Sep 13, 2007
Hi,
I have a little bit of a problem I cannot seem to figure it out. Is it possible to write a Select statement that contains a WHERE column_name > desired_numeric_value
The tricky part it that the column is of CHAR type and can contain numeric grades ranging from 0-100 or the letter I for Incomplete.
My SQL was working perfect when this column contained only numbers as soon as a record with I was added I get the following error:
Character to numeric conversion error
This report will be used to find students who have failing grades. Thanks for any help!
View 5 Replies
View Related
Mar 1, 2014
How to remove non alpha chars from a column ?
I googled the following code
Create Function [dbo].[RemoveNonAlphaCharacters](@Temp VarChar(1000))
Returns VarChar(1000)
AS
Begin
[code]....
View 9 Replies
View Related
Apr 5, 2007
Hello,
I need to strip out all alpha chars and spaces in a given field and return only the numbers.
I've tried =CInt(Fields!Info.Value) and get an unexplained error. If the data was formatted consitantly I could simply do a RTrim or Right, but the number strings are not the same, some have spaces as in phone numbers (1 800 555 1212) or don't have a leading 1. Most instances are correct for my purpose (8005551212).
Any help would be appreciated.
UPDATE: Using the Replace function =Replace(Fields!Info.Value, " ","") gets me almost there. Now I should be able to use a Right, 10 function to return my desired value. Is it possible to combine these two funtions together?
View 4 Replies
View Related
May 3, 2007
hello... my SQL database is being not able to be accessed by application when i run through VS2005 . I created the database in XP sys now brought to a NT systeem..what shd i do ..??? pls help
View 1 Replies
View Related
Mar 11, 2000
I am using windows 98 and I want te use SQL server 7.0. I have installed the non-enterprise edition....But it won't work....
The service manager in istalled succesfully and all the other utilities to.
But it still wont work. Is somebody out there who can help me on this.
Tnx
View 2 Replies
View Related
Apr 12, 2007
I've got XEON x64 server and after SQL Server 2005 installation found that the platform in property says AMD64 and not INTEL64 as expected.
I was assured by our service provider that AMD64 platform is the correct one as it was compiled for INTEL x64.
Does anybody have an answer to it?
View 1 Replies
View Related
May 8, 2006
When I try to run the x86 version of SP1 on my development desktop (for tools only), I get an 'Incorrect Platform' error:
Setup cannot update x86 products on this computer
To proceed, run the Service Pack Setup program for the x86 platform.
The filename I downloaded is SQLServer2005SP1-KB913090-x86-ENU.exe
and it successfully installed on my Wk2003 server (dual PIII). My desktop is a single P4 2.8Ghz running WinXP Pro.
brian smith
View 15 Replies
View Related
Jun 14, 2007
I am writing applications for barcode readers that send and receive information via wi-fi to a 2003 Server running the full MS SQL Server 2005. The readers are both XP and CE .NET 5.00 based.
The information is time critical so I need to scan a barcode then send that information to the SQL Server and then in turn run a query based upon it which then displays on the reader. I have no problem with the XP devices as I can link via ODBC to the SQL Server. These work perfectly.
I can also run a program on a XP desktop using Remote Desktop on the CE device which again works fine.
The CE .NET 5.00 readers are a problem as I cannot use OBDC or OLE DB owing to the platform.
Is there any method available where I can query the SQL Server directly without using some kind of third party product like ViaDB from Odyssey Software? I cannot use replication owing to the time constaints.
Any suggestions or gentle prods would be appreciated.
Norman
View 3 Replies
View Related
Mar 14, 2002
Hi,
We are using VB 6.0 as frontend and SQL server 7.0 as backend. We want to store some special charcters like Alpha, Gamma, etc in the database. We tried different ways but could not find the solution.
Could you please help on this.
Thanks,
Arun.
View 2 Replies
View Related
Jan 25, 2006
Karikalan writes "We need alpha numeric auto increment code in sql server 2000.
(for eg.: ico1001, ico1002, ico1003,......)
Can any one send the code in MS sql server 2000? plz ..................
bcoz i am beginner in sqlserver 2000"
View 1 Replies
View Related
Jul 5, 2001
How can i connect to the MS SQL server ruuning on Windows NT from a SOLARIS machine.?
Is there any client software available for this?
View 1 Replies
View Related
May 3, 2004
Does anyone know why the Extended Stored Procedure API (formerly Open Data Services) headers and libraries (e.g. srv.h, srvdbtyp.h, opends60.lib) are not in the new Platform SDK?
Older versions of the Platform SDK had these tools included, but I installed the new Platform SDK and they're not included. Is there another SDK that I need to download and install now?
View 2 Replies
View Related
Jan 31, 2007
I have to move our dedicated Sql 2000 transactional distributor to a new and faster machine. Great! Can someone give me or point me to a cookbook of the best way to do this? This has to be done quickly so I would like to script it and have it ready ahead of time. I am not a replication guru so I am a bit nervous . . . I have looked at the scripts output by EM, but I am sure there are some assumptions . .
Thanks
View 1 Replies
View Related
