T-SQL Help
-
SQL 2000 8.00.2039 I am trying to write a backup from SQL (.bak), compress it then insert into a database. Can someone help me with the framework of this operation? Any input is greatly appreciated. Regards,
Regards, Hulicat
Hulicat wrote:
Can someone help me with the framework of this operation?
What do you mean by "framework" in the current context?
Upcoming FREE developer events: * Glasgow: Agile in the Enterprise Vs. ISVs, db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website
-
Hulicat wrote:
Can someone help me with the framework of this operation?
What do you mean by "framework" in the current context?
Upcoming FREE developer events: * Glasgow: Agile in the Enterprise Vs. ISVs, db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website
Sorry I should have been more specific. I am trying to accomplish the aformentioned operation via T-SQL. The only way I have seen is via C# or ASP. What would the T-SQL look like to achieve the goal of compressing a .bak file then storing the file in the database? Could I execute a backup, compress it, then drop in the db as a blob?
Regards, Hulicat
-
Sorry I should have been more specific. I am trying to accomplish the aformentioned operation via T-SQL. The only way I have seen is via C# or ASP. What would the T-SQL look like to achieve the goal of compressing a .bak file then storing the file in the database? Could I execute a backup, compress it, then drop in the db as a blob?
Regards, Hulicat
Hulicat wrote:
Could I execute a backup, compress it, then drop in the db as a blob?
Yes. You could use BACKUP, xp_cmd (and call out to a zip application), but I'm not sure how to get it back in the database as I usually do that from within a C# application.
Upcoming FREE developer events: * Glasgow: Agile in the Enterprise Vs. ISVs, db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website
-
Hulicat wrote:
Could I execute a backup, compress it, then drop in the db as a blob?
Yes. You could use BACKUP, xp_cmd (and call out to a zip application), but I'm not sure how to get it back in the database as I usually do that from within a C# application.
Upcoming FREE developer events: * Glasgow: Agile in the Enterprise Vs. ISVs, db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website
-
Hulicat wrote:
It looks like it have to be C3
:confused:
Upcoming FREE developer events: * Glasgow: Agile in the Enterprise Vs. ISVs, db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website
-
Hulicat wrote:
It looks like it have to be C3
:confused:
Upcoming FREE developer events: * Glasgow: Agile in the Enterprise Vs. ISVs, db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website
-
Colin and I are from the UK. The 3 key has the £ sign and not the # sign here.:-D
Deja View - the feeling that you've seen this post before.
-
Colin and I are from the UK. The 3 key has the £ sign and not the # sign here.:-D
Deja View - the feeling that you've seen this post before.
Pete O`Hanlon wrote:
The 3 key has the £ sign
It's not a sign, it's a symbol. How picky am I? ;P
Steve Jowett ------------------------- Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'