Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tuka
Starting Member
26 Posts |
 Posted - 2007-03-19 : 08:46:54
|
| Hi,I amanaged to obtaine a database dump of a database - this is a large file with sql scripts and data around 4 megabytes large. I cannot directly run this file in query analyser due to a file size limit (Not totaly sure if it is 64kb but is is definitely to small for me to run the intended file).Is there any other way i can run the targeted file short of writing a windows program to do so ? Or is there something out there i could try ?TIA,Tuka |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-19 : 08:56:03
|
You said this is "database dump" ? You are referring to a database backup ? Shouldn't you be restoring the database dump ?
KH |
 |
|
|
tuka
Starting Member
26 Posts |
Posted - 2007-03-19 : 09:16:12
|
| No I actually would just like the database dump as an alternative for deployment on a remote host. All it is is a file with sql that recreates the database and all it contains.I would also like to run this file on another computer without bothering to do attaches and detaches.This can be accomplished using this database publishing Scott Guntherie talks about here.See this link : http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Database%20Publishing%20Wizard |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-19 : 09:25:38
|
tried using isql ?
KH |
|
|
|
tuka
Starting Member
26 Posts |
Posted - 2007-03-20 : 11:29:54
|
| Hi,Thanks for the suggestion. I downloaded something similar I had used in the past - QueryCommander and it was able to run the entire script about a 4 Mb text file. It executed fine. had some issues with the script itself but that is another matter.Regards,Tuka |
|
|
|
|
|
|
Executing large files in query analyser