i have a old database in foxpro and it has to be converted to sql server 6.5 database . the table in the foxpro has been broken into more than 1 tables in the sql server . so how can i transfer the data from 1 foxpro table to different tables in sql server 6.5.
vineet
i have an old database in foxpro. The table in foxpro now has been broken into more than tables in sql server 6.5 . how do i append the data to sql server database to the respective tables from the foxpro database.
vineet
Hi all,I am fairly new to using triggers and was seeking some help from thosethat have experience with them. I am looking to transfer data from aSQL 2000 database to a Visual FoxPro database on another computer. Iwould like to transfer about three fields of data to a VFP table eachtime an insert is made on the SQL table. I am some what familiar withthe structure of creating the trigger but here is what I would likehelp with: Selecting the SQL data to transfer, Connecting to VFPdatabase, Insert SQL data into VFP table.CREATE TRIGGER [xyz] ON [dbo].[AAA]FOR INSERT??? Select a,b,c from SQL table??? Connect to VFP Database and Table??? Insert into VFP table Values a,b,cAny information, tips, or even an example Trigger procedure would helpand be greatly appreciated.Thank you,Brett
View 1 Replies View RelatedHi All,
i have mutiple text file. let us say,a1.txtb1.txtc1.txt
i have to port this text file data into the table (SqlServer Database) which have the same file structure.(i.e)x1 (SqlServer table)y2 (SqlServer table)z3 (SqlServer table)
now i have to transfer a1.txt file data ----to--- x1b1.txt file data ----to--- y2c1.txt file data ----to--- z3
using SSIS. like that, i have to transfer more than 250 files at a time.manually binding 250 files into the package is very cumbersome and time consuming process.
so, can any one give ur valuable sugession to solve this issue.
hello,guys,
my question is :
how do I query data from the linked foxpro database?
more:
I have linked a visual foxpro server to my sql server database by using the addserver clause.
Two server is in a local network.
My linked foxpro server named 'fox'.
its datasourse is not a dbc file, but a directory of dbf files ,and its full path is d:foxpro object.
In the directory ,there are three table,'show2003.dbf','sysu.dbf','szszj.dbf'.
And the .dbf files are not in any database.
They are just three files in the same directory.
There is no dbc file.
Now I can see the table list on the right page of the linked server.
But there is something wrong with my sql clause.
sample:
select * from fox..sysu
then the message is:
server: message 7313，level 16，status 1，row 1
the appointed constructure or directory to the provider is inefficacious 'MSDASQL'
I know I may use 'openquery',or 'openrowset'.
The problem is that variable is not valid in 'openquery' and 'openrowset'.
But I must use variable.
so ,please give me some advice.
Thank you very much
Hi,
I'm new to SQL server, and I would like to achieve below tasks. Kindly
provide brief guildline on how to achieve these:
1.) I have managed to schedule job in SQL server to download the access database from remote server.
2.) Second, I would like to transfer all the data from my acccess database to my SQL tables.
May I know how do I achieve my task no 2???? I believe I need to write some script (procedure) in order to achieve this.
pls advise....
Insert data to database foxpro using open query. I already create connection like below
@server = 'EXIMBIL_LINK',
@provider = 'MSDASQL',
@srvproduct = '',
@provstr = 'Driver={Microsoft Visual FoxPro Driver}; UID=;SourceDB=D: raining_testdata;SourceType=DBF ;Exclusive=No;BackgroundFetch=Yes'
when i try to show table van with command :
select * from openquery(EXIMBIL_LINK,'select * from van')
It show query running well but when i try to insert new row to table van with command :
INSERT into OpenQuery(EXIMBIL_LINK, 'SELECT c_user_id,c_user_name,full_name from van')
VALUES('1000007668','IDMTEST2','IDMTEST2')
throws error like this : Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done
I have a client who was installed improperly on a Case InsensitiveCollation SQL system and have been working with this system for over ayear. For them to move forward in application software versions, theywill need to be reinstalled on a Case Sensitive SQL system. I waswondering if anyone has tried this and was willing to provideinformation that may be of assistance? I have tried various someoptions within DTS but without success.
View 1 Replies View RelatedHi,
I want to transfer some tables and their data from a database to another database so what is the best way of doing..
In the source Database i right click on that table and then gave Script table and then selected Create To and then copied that create table query and pasted it in the destination table..
So is there is way i can get the rows from all of that table.. There are around... 1000 rows or something like that and that database consits of 5 - 6 tables.
any help will be appreciated..
Regards,
Karen
Greetings, I have just arrived back into the country (NZ) and back into ASP.NET.
I am having trouble with the following:An attempt to attach an auto-named database for file (file location).../Database.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
It has only begun since i decided i wanted to use IIS, I realise VWD comes with its own localhost, but since it is only temporary, i wanted a permanent shortcut on my desktop to link to my intranet page.
Anyone have any ideas why i am getting the above error? have searched many places on the internet and not getting any closer.
Cheers ~ J
Hi all,
Currently, my (small) intranet site is storing it's data on a remote SQL server. The danger with this, as has happened several times now, is that the application is twice as vulnerable; if either the webserver or the dataserver malfunctions or is unreachable, the application won't work.
I only recently discovered the possibility to use local database files (MDF files), and this seems like a much better solution for my site. But now I want to transfer the tables that are residing on the dataserver, to the MDF file. The database only contains tables. How do I handle this? I do not have access to the dataserver, only to a few databases that are residing on it. Is this possible using Visual Studio 2008? I have read about a "Bulk Copy Program" (bcp) which is included with SQL Server, but I cannot find a download for just that application.
Or is this totally not the way to go? I've discovered MDF files are a bit more problematic with concurrent connections; having tables open in Visual Studio results in "Site offline" or "Cannot open database" error messages on the website. Problems I've never had to deal with using SQL Server, but they are only minor problems.
Thanks,
Peter
Ok, so thank you first off to Arnie for helping with my auto-increment problem. I'm not in the office now, but I can't wait to try out what he showed me to get this thing running.
My bigger problem that I'm hoping you guys can help me with though is this:
I have two servers, and two databases, lets call them dev, and staging. These are exactly the same, except in different physical locations, and changes are made on dev, and then the info is updated to staging. I am writing a C# script to automate the process of updating the information from the dev database on the dev server, to staging. I am profficient with C#, but this is the first time i've ever touched SQL.
So by using the INSERT and SELECT method, I can get the info over properly, I am assuming (as I said I haven't been in the office to try it out yet) but for each table on the database there are different sets of column names, so I can't do a simple
Loop{
SqlCommand del = new SqlCommand("Truncate table " +MyTable", connectionstring)
del.ExecuteNonQuery();
SqlCommand com = new SqlCommand("INSERT INTO MyTable (MyColumn)
SELECT MyOtherColumn FROM MyOtherTable", connectionstring);
com.ExecuteNonQuery();
}While(...) and change the MyTable/MyOtherTable values for each loop.
Is there a quick and easy way of calling a list of columns for each table, so that I can change the table value, get the list of columns, and assign those as a variable? That way it can run through every table on the database, and no matter what the number or names of the columns in each table, it will grab all the necessary data and pass it over.
Thanks in advance,
Aaron L
I am having two dataBases in Sql Server 2008 both are live and both have same schema.
On Server 1, I have crores of data in a table.
I would like to move it to Second database .
What will be the fastest way to do.
What is the best approach when transferring all database objects & data from a SQL Server 6.5 database to SQL Server 7.0 database running on different servers.
Thanks in adavance for your tips
Cheers,
Phil
Hi,
I 'am working with SQL Server7.0, and I need to transfer bulk of data(in millions) from aremote database in Rdb to SQL Server. What is the best approach other than using a comma delimited flat file? Is there a way to create a database link and then use a copy script in SQL to copy the data directly? I would appreciate any help. Thank You.
Jothi
Guys
i have two database on my sql server,, and i m trying to create a report in whch both database need to share their data.. @ the moment what i did, i simply create a view on one database to access the table of other database.. but is anyone has a better idea how can i transfer data from one database to another database... i think if i do with creating temp table that might resolve this problem.. but when it comes on another server of another database , how can i will do this ...
please give me any idea if u got my point .
Thanks and looking forward.
I have question regarding SQL Transactional Replication methodology
1. Let's say successfully created SQL Transactional Replication and running / transferring data from publisher to subscriber
2. Now one day the source production / publisher SQL Server is down and the remaining DR SQL Server is up (subscriber)
3. Next day, we fixed and bring up the production / publisher SQL Transactional Replication server, then how can we sync back all existing data records from subscriber into publisher side ?
Transfer tables with Data from one database to another one on a same server?
View 10 Replies View RelatedIs there a way to transfer data from a SqlServer db to a SqlServer Express db. I tried to use the backup file of SqlServer, but this file is not valid for SqlServer Express. Or there any alternatives?
thanks,
Henk
yes,I have an error, like 'The database file may be corrupted. Run the repair utility to check the database file. [ Database name = SDMMC Storage Cardwinpos_2005WINPOS2005.sdf ]' .I develope a program for Pocket Pcs and this program's database sometimes corrupt.what can i do?please help me
View 4 Replies View RelatedHi All,1. i want to transfer the .csv file data into sql server table, itried with the DTS but while creating DSN it not prompt to attechthe .csv file. give me the proper steps to perform the datatransfer...2. i want result of my query into excel or text file by using the sqlquery( like Select * from employee where emp_salary>10000 to 'c:emp.xls).i know the other way right click into query analyzer windowand select option result to file, but want the result by using SQLquery.....
Quote:
In the full recovery model, if i run a transaction that inserts 10MB of data into a table, then 10 MB of data is moved in the data file. Does this mean then that the log file will grow by exactly 10MB as well?
I understand that all transactions are logged to the log file to enable rollback and point in time recovery, but what is actually physically stored in the log file for this transactions record? Is it the text of the command from the transaction or the actual physical data from that transaction?
I ask because say if I have two drives, one with 5MB/s write speed for the log file and one with 10MB/s write speed for the data file, if I start trying to insert 10 MB of data per second into the table, am I going to be limited to 5MB/s by the log file drive, or is SQL server not going to try and log all 10 MB each second to the log file?
Hi Everone,
I need help on how to produce a SQL Server Database Primary Data File, i have read the Visual C# 2006 book by Deitel and Deitel unfortunately the book does not say how to produce the forementioned data file. The software that i currently have to help me produce this data file is Visual C#, J#, Web Development, SQL Server 2005 and Office 2007.
I have a good understanding of databases from studying SQL and Oracle but i am not sure which is the best software to use to produce the Primary Data File, ideally i would like to use Access from my Office 2007 package.
Many thanks for your help in resolving this problem.
Does anyone know how to attach a Foxpro database to SQL Server Express?
Thanks,
Grant
Hi
I was wondering if any one out there could help me out here. We are using SQL Server 7.0, we have purchase a new server, what will be the best procedures to transfer the current database to the new server? I look forward to hearing from anyone, also I wish you all a Merry Christmas & Happy New Year.
I shall remain.
E. Warden
Hi,
I am new to the database concepts, maybe my questions are very basic.
I transfered data from one sql server to another thru object/database transfer. The transfer was successful, ie.,
all the data was present in the new server too. I am using an application with ASP as front end and SQL server 6.5 as back end.
So i am able to all new records, delete them, update them thru my ASP programs. But, i am not able to update the records
which where transfered from the old server. I hope some one of can help me, as i said earlier i am new to databases,
so give me a detailed solution.
Thanks,
Karthik narain
May I know how to transfer Microsoft SQL Server's database from 1 PC to another PC?
What I doing now is export the Microsoft SQL Server database to Microsoft Access format, then import it to the SQL Server of another PC.
But the field type have to reset again.
Any method that the table's field type is same after transfer to new PC?？
＊field type = int, varchar etc
Thx~
there is applications which were written in FoxPro. Recently it has been redone in SQL.
How can I check that Whether their server designated to host the database is ready and fully up to spec on revs and patches,If not how and who can bring it up.
and How can I determine what else needs to be addressed to ensure a smooth transition and implement?
Define ongoing maintenance requirements.
On the web site for MS SQL Server 05 Express the description at the top of the page says, "Transfer any database created in SQL Express to other editions of SQL Server 2005." http://msdn.microsoft.com/vstudio/express/sql/powerful/
How do you transfer a database from SQL Express to SQL Server 2005?
I am creating a data-driven web site using Visual Web Developer 05 Express, SQL Server 05 Express, and MS SQL Server Management Studio Express. My host uses SQL Server 2005, ASP.net 2.0, and FrontPage extensions.
Thanks for your help.
Hi,How could i do to convert data from CSV files to tables on database in SQL server 2000 ? Please show me !Thank very muchdvl_lang
View 3 Replies View RelatedWe have a process here where a ~45Gb is copied from DB1 to DB2 (both on the same server) using the Export Data wizard and choosing the "Transfer objects and data between SQL Server 7.0 databases" - All the defaults are left as is.
Under 6.5 this method took around 24 - 26 hours, now with SQL 7.0 (SP3) it takes about 16 hours. That's great execpt towards the end of the copy it seems to be hogging most of the server resources - although the processors aren't mazed out.
Users of the other databases are having queries take 5+ mins when they normally come back in < 5 seconds. As soon as the copy finishes there query time return to 'normal'.
Anyone any ideas on where to start looking or how to analyse this problem.
Thanks in advance.
Rob Elmes
Hello,
On the web site for MS SQL Server 05 Express the description at the top of the page says, "Transfer any database created in SQL Express to other editions of SQL Server 2005." http://msdn.microsoft.com/vstudio/express/sql/powerful/
How do you transfer a database from SQL Express to SQL Server 2005?
I am creating a data-driven web site using Visual Web Developer 05 Express, SQL Server 05 Express and MS SQL Server Management Studio Express. My host uses SQL Server 2005, ASP.net 2.0, and FrontPage extensions.
Thanks for your help.
Hi
I'm going to put my database in setup file that I've been ready before.
My Software could be use from database after installing in every system , but other users won't be able to access to data or structure of database , even with adding of database to SQLServe Enterprise Manager .
How Should I can do about this ?
Tanks very much