I need to generate the Sql Scripts for a particular Database in a Sql Server 7.0.
Also i need help in the Data Migration of Foxpro2.6a to SqlServer.
If there are any good tools for such conversion,I am very much thankful to all who comes with a good reply.
Thanks & Regds,
B.SethuJust right click any of your databases and choose "all tasks" then "generate sql scripts". If you have an odbc driver for the foxpro database then you can use the dts import wizard. If not, just export the foxpro database to a delimited file and use the wizard.|||To migrate your data look into Distributed Transaction Coordinator (DTS),which comes with SQL Server. Also use Google (http://www.google.com) to research on the migration.|||Thanks for the reply.I need to create Insert Statements for all my Master Tables(say 1000).I need a tool which gives me the insert statements,either if i give the Database or Tables of the Database.
Also for foxpro we don't have any ODBC driver,moreover my all foxpro tables have memo fields,which i can't transform via DTS.
Thanks & Regds,
B.Sethu|||To generate the scripts for all of your databases you can use the sql-dmo script method - look at your books online.
What happens when you try to transform the foxpro table with a memo field ?|||I've created a stored procedure that will generate the INSERT statements
Example in Pubs database
exec usp_CreateInsert authors
INSERT authors ( au_id, au_lname, au_fname, phone, address, city, state, zip, contract)
VALUES ('409-56-7008','Bennet','Abraham','415 658-9932','6223 Bateman St.','Berkeley','CA','94705',1)
INSERT authors ( au_id, au_lname, au_fname, phone, address, city, state, zip, contract)
VALUES ('427-17-2319','Dull','Ann','415 836-7128','3410 Blonde St.','Palo Alto','CA','94301',1)
I've attached the script|||For the foxpro conversion - have you tried converting to access first then to sql server ?
Showing posts with label particular. Show all posts
Showing posts with label particular. Show all posts
Wednesday, March 7, 2012
Monday, February 20, 2012
Near exact matches, help needed
I'm currently working on a match function to compare two char based columns in differnet tables to create a join.
In this particular case, I'm using a few different approaches to create a higher match ratio, as typos do happen.
For instance I use a join function using convert(char(10), tbla.field) = convert(char(10), tblb.field) to match only using the first 10 characters, as a lot of records have different endings, but are in fact the same.
Are there any other ways I could attempt to make matches? I was wondering if there was a dedicated string comparison operation giving me a percentage feedback. Debut joining dbut would give an 80% match, and thus I would leave it up to the user to decide to minimum match requirements.
Thanks in advancePerhaps the SOUNDEX function could help you out: SOUNDEX - Returns a four-character (SOUNDEX) code to evaluate the similarity of two strings.
In this particular case, I'm using a few different approaches to create a higher match ratio, as typos do happen.
For instance I use a join function using convert(char(10), tbla.field) = convert(char(10), tblb.field) to match only using the first 10 characters, as a lot of records have different endings, but are in fact the same.
Are there any other ways I could attempt to make matches? I was wondering if there was a dedicated string comparison operation giving me a percentage feedback. Debut joining dbut would give an 80% match, and thus I would leave it up to the user to decide to minimum match requirements.
Thanks in advancePerhaps the SOUNDEX function could help you out: SOUNDEX - Returns a four-character (SOUNDEX) code to evaluate the similarity of two strings.
Subscribe to:
Posts (Atom)