I have migrated sybase database to sql server it seems successfully migrated, we required to validate data and datatype before going to production, how can this be achieved, kind of stored procedure which can be run both sides (sybase and sql) and validated in some way.
View 5 RepliesI am currently in the process of migrating data from Sybase to Sql server and would like to know how to test the data migrated.
As of now, we took one table data from both source and destination and compared it in Excel to check if the data migrated looks good (note, we used SSIS to migrate data). However, I would like to check if there are any other best & easy ways to apprach data validation post migration.
Hi all
I have a problem with the migration of databases from sql 2000 to sql 2005.
When i try to create the table or when i try to import the database, the below message is prompt:
Mens. 2782, Nivel 16, Estado 1, Línea 1
La instrucción DDL no está permitida.
Any ideas about this problem?
Thanks in advance
We have an old client server application (vb / sql 2000) we have now converted that application to a web based asp.net / sql 2000. Though the db is same (sql 2000) for both applications, tables/columns has been changed during the development process. Now i need to migrate the data from our old db to this new db. Should this be done the "painful" way of checking each and every table its links/dependencies, columns manually or is there a tool which helps me migrate the data from one db to another (even though the tables/columns are different)Please Help.Thanks.
View 3 Replies View RelatedHi,
How do i migrate my DataBase From sql serevr 2000 to 2005? Including the data. In 2000, it was easy through DTS (Copy SQL Server Objects Task: undefined). But don't any thing of that type in 2005(SSIS). Kindly Help...........
Thanks,
Rahul Jha
HI Guys
I have a large MYSQL database that I need to migrate to MS-SQL Server 2005. Are there any good tools available to do this with ?
:eek:
Hi All,
I have created new xyz database in one of our sql server 2005. Now I want to restore the YTR database from sql server 2000 server and I also wanted my SQL server 2000 logins/users and thier permissions remain same on YTR database.
Urgent help would be appreciable.
Regards,
Frozen
Hi,I wonder wether a software or a device (or script) allowing to migrate datafrom an existant database to a new database by using correspondant ODBCdrivers existed.Thanks for your help.
View 2 Replies View Related
Can any one help me to migrate SQL Server 7.1 databse to SQL Server 2000.
Thanks in advance
Hi all,
I am new in SSIS. Anyone know how to valify number of record that I load from csv file to SQL database table?
For example, the source file call product.csv and target table in database named DSS table name PRODUCT. I load data from flat file to table then I need verification if count between source and target not match send e-mail to me.
Thanks.
Grace
Hi i have had a few problems taking a database backup .bak from an SQL Express install on one server i.e. SQLHOST/SQLExpress and moving it to a new machine in a different office i.e. MASTERSERVER/SQLExpress
Does anyone have any ideas on this?
Thanks
Can you tell me what is the best practice for SQL database migration fromone DB server, to another one, new DB server. The old DB server will beremoved.1. Backup from old and restore all databases on the new server2. Export data and copy/import on a new server3. Something else...Thanks in advance for any good advice...Regards
View 2 Replies View RelatedCould someone help us with a problem we're having with regard tomoving several databases from SQL 7 to SQL 2000 on different serversin different domains. Our current SQL 7 server resides in one domain,and holds several databases. We now want to move these to a SQL 2000server in another domain.We're trying to use the Copy Database wizard on the SQL 2000 server(logged in as the local admin account), selecting the SQL 7 server asthe source, using 'sa' account on that server. The target is the SQL2000 server, again using 'sa' account. We're leaving everything elsewith regards to logins, jobs etc as default (i.e. taking everythingthat can be found), but when the steps execute, the last step thatbrings the database across fails with an error code -2147467259 -Failed to create the share OMWWIZI.Can anyone help us out with this error, or provide any suggestions asto what we can do?Any help would be greatly appreciated. Thanks.
View 2 Replies View RelatedHello,
I'm new to databases but not to programming in general. I've got a few applications which currently sit on a single PC and read/update a particular XML file on the box. The applications are C# apps and use FileSystemWatchers and a mutex to keep watch for changes and update the XML file as needed. It has worked reasonable well for me.
Now, I need to run these applications on separate machines, so it seemed a good point to consider moving toward a database solution.
I'm hoping that there is a straightforward solution using SQL Server that will ensure that my applications alway have the current view of the world. I had run into instances with my existing setup where once in a while an application thought its DataSet was up to date, but wasn't.
Can someone point me in the right direction to implement the solution? I suspect that this is a really common need for lots of programs that are distributed. I'm still quite a newbie with databases and SQL Server, so I'm not even sure I'm using the right terms to describe things.
Thanks,
Matt
Usually when in the process of migration, how to calculate how much time it will take to migrate the database. If a database full backup is taking approximately 3 hr how much time it will take to restore that database.
Which process is better to migrate the SQL server from 2008 to 2014.
Database migration wizard or restoring the db using backup file?
Usually if you are new to the sql server and you don't have any idea about the OS how can you find how much time it will take for migration for each database and for all databases
Hello there..... im currently running a mysql database and i want to switch to a mssql database structure... creating the database is not a issue, but inserting values is a problem...
my forum has a lot of data and moving one row at a time is near insanity....
i tried this. ---
Code Snippet
INSERT INTO si_acl_groups ("group_id", "forum_id", "auth_option_id", "auth_role_id", "auth_setting") VALUES
(100, 0, 0, 14, 0),
(96, 0, 15, 0, 1);
but i only get this error. ---
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near ','.
any suggestion...
i was able to dump the mysql database into a .sql file but it just gives the same error when i execute...
please help...
I'm trying to migrate tables from one database to another. The tables in the source database (MY_SOURCE_DB) have a schema of "dbo". I want to create the tables in the target database (MY_TARGET_DB) with a schema of "xyz". I want to migrate all of the tables with "contract" in the table name:
select table_name from information_schema.tables
where table_name like '%contract%'
I want to migrate the full table definitions, table data and dependent objects. This needs to be done through a sql script as opposed to SSIS.
Hi,
Is there any tool available to migrate the data from the SQL Server
test database to SQL Server production database. Data Migration should
be based on a condition which can be given as an input for a table by
the user. The dependant tables also should be migrated based on the
condition. i.e data subsetting based on the matching conditions.
Ex : Salary > 2000
The rows of the table which matches the condition alone need to be
migrated for the corresponding table. Also its dependant table's
rows should be migrated based on the given condition. Please help me
with a tool which can automate this.
Thanks,
Smitha
hi,
I migrated the Northwind database using SQL Migration Assistant for Access. it worked fine and I was able to link the access forms to Local machine SQL Server 2005 and it worked fine.
Now i want to link the same Northwind access database to Another Server on the network.
When i try to run the wizard again, it won't migrate the user objects like tables to server, it will just create a database and that is it.
it will give me this error too.
No User objects were selected.
any idea,
Thanks,
Fahim
I've installed SQL 2005 Express Addition which created a default database using Windows Authentication -- MachineName/SQLEXPRES. I want to convert some access databases to sql server in the migration assistant, however, when I try to connect the migration assistant to the default database I can't find the database in the drop down box wizard? I'm perplexed? Please shed some light or point me to some articles that will help. Thanks.
I want to move table from one database to another database in same instance, table should migrated with complete data,with same column data type, all constraints like PK,FK unique key, check, identity, permissions has to be there.. which is the right way to achieve this.
View 7 Replies View Relatedwe want to completely do away with access, on my report tool,which is crystal report, we want query to be our data source so , we do not want to use ssis packageor import from access to sql, how can l handle bringing all table and the query from Access together.
View 1 Replies View RelatedHi,
Is there any tool available to migrate the data from the SQL Server test database to SQL Server production database. Data Migration should be based on a condition which can be given as an input for a table by the user. The dependant tables also should be migrated based on the given condition. i.e data subsetting based on the matching conditions.
Ex : Salary > 2000
The rows of the table which matches the condition alone need to be migrated for the corresponding table. Also its dependant table's rows should be migrated based on the given condition. Please help me with a tool which can automate this.
Thanks,
MiraJ
Hi,
i was planning to create a database migration tool ..
its a certain database of a DMS (document management system) to
another DMS (two different DMS)... from DMS using msde 2000 server .. and tranfer to a DMS using a postgre sql or mssql .. depends ..
they have different table structures and names . . :D
i was thing of what language shall i use.. or what language is the best to work on this kind of project :)
hoping for your kind help guys. thanks :)
br
Frozenice
I am working on a query application, and I want to do syntax validation before I submit the dynamically sql to the database. The expression will include ANDs, ORs, IN, (,),>,<,etc. Anyone done this already? any code snippets?
Thanks!
Hi
I am running the following:
DECLARE @h uniqueidentifier --conversation handle
DECLARE @msg xml; --will hold the message
BEGIN DIALOG CONVERSATION @h
FROM SERVICE [ewx.co.za/Service/store001_ewx_sb_service]
TO SERVICE 'ewx.co.za/Service/ewx_sb_hub_service'
ON CONTRACT [ewx.co.za/Contract/ewx_Contract];
SET @msg = '<InventoryUpdate>
<TitleId>STORE001TEST1</TitleId>
<Quantity>7777</Quantity>
</InventoryUpdate>';
SEND ON CONVERSATION @h
MESSAGE TYPE [ewx.co.za/Message/ewx_sendmsg](@msg);
Now to test errors comming back on the aueue i sed to make the xml tags wrong, then the target would send a error back on the queue with xml validation failed (both queues have validation well_formed_xml). However now in testing i cannot even send the message i get an invalid xml error straight away, i am not sure why this is , i know the xml is not valid but the send used to work and i would get an erro rback, as the xml is validated by the ttarget, but this no longer works it ails strainght away, with no thing in any queue. What could be causing this ?
Thanx
I think I have read online a recommendation about not using XML VALIDATION in a production environment, due to performance reasons. Is it recommended using other that NONE validation in production, and is there available documentation for a scale that grades performance hits for various types of validations?
Thanks
Afternoon all,I want my SQL SP to do some validation on a form submit to do the following before committing to the table.If email address (txt.Email.Text) doesn't exist in the table, commit values.if email address (txt.Email.Text) does exist and option (radOptions.SelectedValue) equals 1, print message to say 'you're already subscribed'if email address (txt.Email.Text) does exist and option (radOptions.SelectedValue) equals 0, print message to say 'you're not subscribed'if email address (txt.Email.Text) does exist and option (radOptions.SelectedValue) equals 1 or 0, update row to 0 or 1 (depending on subscribe or unsubscribe - 1 = subscribed, 0 = unsubscribed) The simple SP is currently:ALTER procedure [dbo].[sp_customerSignups]@name varchar(50),@email varchar (50),@subscribed intasBEGININSERT INTO tblCustomerSignups(Name, EmailAddress, Subscribed)VALUES(@name, @email, @subscribed)END Does anyone have the correct syntax for this?Thanks,Brett
View 4 Replies View RelatedHi,
I have following XML-file and XML-schema:
<template xmlns="http://www.mycompany.com/xsd/PageTemplate">
...
</template>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns="http://www.mycompany.com/xsd/PageTemplate" targetNamespace="http://www.mycompany.com/xsd/PageTemplate"><xs:element name="template"><xs:complexType>...</xs:complexType>
</xs:element></xs:schema>
When I create and query the XML file using LINQ, everything works just fine. I also get no compilation errors.
But when I try to add the XML file to a database-field of type xml(CONTENT dbo.Common7), I get following error:
XML Validation: Declaration not found for element 'http://www.mycompany.com/xsd/PageTemplate:template'. Location: /*:template[1] Any ideas? Thanks,Thomas
Hey all,
Quick question regarding validation!
I have a table of contact details containing the usual name, adresss etc fields.
I want to validate the fields Country and telephone together so that fopr example if country = 'UNITED KINGDOM' the telephone has to begin with +44 if it doesnt i want it to add the +44!
I can do this through writing a little program but just wanted to explore the possibility of doing this with SQL or functions already available with MSSQL Server
cheers
ed
i have two params..
@startdate datetime,@enddate datatime
1.what's the best way to validate them
2.Best way to check whether @startdate is less than @enddate
I need to make sure that a string contains at least one number, at least one letter and has no repeating chars. Anyone done something similar? What's the best way to do it? Thanks.
View 14 Replies View RelatedI am new to SQL SERVER,
Can anybody help me to write a procedure to validate a given string like
09461020(Y2K compliant date), I need to check wether this is a valida date or not??
0946 = should convert to 1946
10 = month
20 is the date.
If it is 20461020.....then year = 2046, month = 10 and day = 20..and it is valid.
procedure should return validate date or not ...return TRUE OR FALSE.