Now add a new agent job to Build SSIS. Click the + icon.
Leave the rest of the fields as default.
That's everything for Azure devops continuous integration/ continuous deployment process for releasing ssis project to azure sql server. Good luck!
Now add a new agent job to Build SSIS. Click the + icon.
for example, the login name is 'mysqluserlogin'
1) Enable the disabled login:
ALTER LOGIN mysqluserlogin ENABLE;
2) Change the login password:
ALTER LOGIN mysqluserlogin WITH PASSWORD = 'thisismynewpassword*&£1';
3) Change the login name:
ALTER LOGIN mysqluserlogin WITH NAME = mysqlusernewlogin;
You'll need Microsoft SQL Server Management Studio to run the below query.
Select the database where you want to run the query against.
Open a new query window and run the below command
DECLARE @SanjeebXsdSchema xml
SET @SanjeebXsdSchema = (SELECT top 1 * FROM [dbo].[BOM_DW_Extract] FOR XML AUTO, ELEMENTS, XMLSCHEMA('sanjeebXsdSchema'))
SELECT @SanjeebXsdSchema
Result:
<xsd:schema xmlns:schema="sanjeebXsdSchema" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sqltypes="http://schemas.microsoft.com/sqlserver/2004/sqltypes" targetNamespace="sanjeebXsdSchema" elementFormDefault="qualified">
<xsd:import namespace="http://schemas.microsoft.com/sqlserver/2004/sqltypes" schemaLocation="http://schemas.microsoft.com/sqlserver/2004/sqltypes/sqltypes.xsd" />
<xsd:element name="dbo.BOM_DW_Extract">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="CompanyCode" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth" sqltypes:sqlSortId="52">
<xsd:maxLength value="50" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="ParentPart" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth" sqltypes:sqlSortId="52">
<xsd:maxLength value="50" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="ComponentPart" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth" sqltypes:sqlSortId="52">
<xsd:maxLength value="50" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="ComponentSequence" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth" sqltypes:sqlSortId="52">
<xsd:maxLength value="50" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="ComponentQuantity" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth" sqltypes:sqlSortId="52">
<xsd:maxLength value="50" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Reference" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth" sqltypes:sqlSortId="52">
<xsd:maxLength value="20" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="BomType" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth" sqltypes:sqlSortId="52">
<xsd:maxLength value="20" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="StartDate" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth" sqltypes:sqlSortId="52">
<xsd:maxLength value="50" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="EndDate" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth" sqltypes:sqlSortId="52">
<xsd:maxLength value="50" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="ModifiedDate" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth" sqltypes:sqlSortId="52">
<xsd:maxLength value="50" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>
I've assumed you have already configured domain in azure and have created a domain user.
Create Application in app registration
First of all Create an app registration [myssissqlserver01]
Now Go to the sql server (not the database) and on settings menu, click Active directory Admin
Connect to the database using MS Sql server management studio
Once admin is set , Open MS Sql server management studio and connect to the database.
Since we have added user to active directory admin, the user will have access to master database. So we can choose default database to connect,
Create a user in ssis and add to a suitable role
Create a new query window selecting SSISDB database
execute the below queries. Note that the user name should be identical to the Application name created in App registration section . [ myssissqlserver01]create user [myssissqlserver01] from external provider;
exec sp_addrolemember [db_owner],[myssissqlserver01];
declare @n datetime = dateadd(mm,0,getDate())
declare @FirstWeekDayOfMonth int
SELECT @FirstWeekDayOfMonth= CASE
WHEN Datename(dw, Dateadd(dd, -Datepart(dd, @n) + 1, @n)) = 'Saturday' THEN Day(Dateadd(dd, -Datepart(dd, @n) + 3, @n))
WHEN Datename(dw, Dateadd(dd, -Datepart(dd, @n) + 1, @n)) = 'Sunday' THEN Day(Dateadd(dd, -Datepart(dd, @n) + 2, @n))
ELSE Day(Dateadd(dd, -Datepart(dd, @n) + 1, @n))
END
select @FirstWeekDayOfMonth
Note: to find out first day of next month , change first line to dateadd(mm,1,getDate())
1st day of next N month , change the first line to dateadd(mm,n,getDate())
Microsoft Visual studio Test Framework
Install smbclient :
sudo apt update
sudo apt install smbclient
List the share items in the server:
smbclient -L host
for example: smbclient -L 192.168.0.30
you need to enter password.then you'll see the result like this:
Domain=[WORKGROUP] OS=[Windows 6.1] Server=[Samba 4.9.5-Debian]
Sharename Type Comment
--------- ---- -------
print$ Disk Printer Drivers
RaspberrypiShare Disk
IPC$ IPC IPC Service (Samba 4.9.5-Debian)
pi Disk Home Directories
Domain=[WORKGROUP] OS=[Windows 6.1] Server=[Samba 4.9.5-Debian]
Server Comment
--------- -------
RASPBERRYPI Samba 4.9.5-Debian
Workgroup Master
--------- -------
To browse Shared folder :
smbclient \\\\192.168.0.30\\RaspberrypiShare pa$$w0rd
Open the console/terminal in the desktop or
Connect to the raspberry pi via ssh and type in the below commandAfter installation of python in windows 10, python is not added to environment variable by default. If you want to use cmd for python, then python installed path must be configured in the environment variable.
By default, Android studio can not connect to the Azure devops source codes. To connect to the Azure devops, a plugins by Microsoft needs to be installed in the android studio. To install the plugin, follow the below steps:
to run the below command , start PowerShell in visual studio. Select the database project. In PowerShell: Script-Migration this command wi...